{ "cells": [ { "cell_type": "markdown", "metadata": {}, "source": [ "# Lab 25 - Part 2\n", "\n", "First, let's import the necessary libraries." ] }, { "cell_type": "code", "execution_count": 5, "metadata": {}, "outputs": [], "source": [ "import numpy as np\n", "import matplotlib.pyplot as plt\n", "import pandas as pd\n", "%matplotlib inline\n", "pd.set_option(\"display.max_columns\",None)" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "### Are the complaints in zip code 10468 different than in New York City as a whole?\n", "\n", "Zip code 10468 contains Lehman College. We will test whether the distribution of complaints in this zip code is the same as the distribution of complaints in all of New York City.\n", "\n", "Null hypothesis: The complaints in zip code 10468 have the same distribution as complaints made in New York City as a whole.\n", "\n", "Alternative hypothesis: The complaints in zip code 10468 have a different distribution as complaints made in New York City as a whole.\n", "\n", "Test statistic: The Total Variation Distance (TVD) from Lab 14. Recall the TVD is computed between two distributions by taking the absolute difference of the probabilities for each category, summing them, and dividing by 2. \n", "Ex. `np.abs(df[\"Distribution 1\"] - df[\"Distribution 2\"]).sum()/2`\n", "\n", "Load the CSV file with call data from March 3 and 4, 2019 into the dataframe `calls`. Read the `Created Date` column in as a date/time." ] }, { "cell_type": "code", "execution_count": 6, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
Unique KeyCreated DateClosed DateAgencyAgency NameComplaint TypeDescriptorLocation TypeIncident ZipIncident AddressStreet NameCross Street 1Cross Street 2Intersection Street 1Intersection Street 2Address TypeCityLandmarkFacility TypeStatusDue DateResolution DescriptionResolution Action Updated DateCommunity BoardBBLBoroughX Coordinate (State Plane)Y Coordinate (State Plane)Open Data Channel TypePark Facility NamePark BoroughVehicle TypeTaxi Company BoroughTaxi Pick Up LocationBridge Highway NameBridge Highway DirectionRoad RampBridge Highway SegmentLatitudeLongitudeLocation
04186492103/03/2019 12:00:00 AM03/08/2019 12:00:00 AMDOHMHDepartment of Health and Mental HygieneRodentCondition Attracting RodentsCommercial Building10314.02216 VICTORY BOULEVARDVICTORY BOULEVARDCARMEL AVENUEO'CONNOR AVENUENaNNaNADDRESSSTATEN ISLANDNaNNaNClosed04/02/2019 09:27:17 AMThe Department of Health and Mental Hygiene wi...03/08/2019 12:00:00 AM01 STATEN ISLAND5.007350e+09STATEN ISLAND946124.0162287.0ONLINEUnspecifiedSTATEN ISLANDNaNNaNNaNNaNNaNNaNNaN40.612035-74.137318(40.612034696062125, -74.13731846061239)
14190725503/03/2019 12:00:00 AM03/08/2019 12:05:00 PMDEPDepartment of Environmental ProtectionAsbestosAsbestos Complaint (B1)NaN10017.0155 EAST 47 STREETEAST 47 STREETLEXINGTON AVE3 AVENaNNaNADDRESSNEW YORKNaNNaNClosedNaNThe Department of Environmental Protection inv...03/08/2019 12:05:00 PM06 MANHATTAN1.013020e+09MANHATTAN991730.0214097.0UNKNOWNUnspecifiedMANHATTANNaNNaNNaNNaNNaNNaNNaN40.754320-73.973002(40.754320163093986, -73.97300174054661)
24186506203/03/2019 12:00:00 AM03/12/2019 04:39:55 PMDOHMHDepartment of Health and Mental HygieneRodentMouse Sighting3+ Family Apt. Building11225.0390 EASTERN PARKWAYEASTERN PARKWAYFRANKLIN AVENUEBEDFORD AVENUENaNNaNADDRESSBROOKLYNNaNNaNClosed04/02/2019 03:44:08 PMThe Department of Health and Mental Hygiene wi...03/12/2019 04:39:55 PM09 BROOKLYN3.012668e+09BROOKLYN996465.0183471.0PHONEUnspecifiedBROOKLYNNaNNaNNaNNaNNaNNaNNaN40.670254-73.955967(40.670253828660485, -73.95596683374993)
34186461503/03/2019 12:00:00 AM03/03/2019 12:00:00 AMDOHMHDepartment of Health and Mental HygieneRodentMouse Sighting3+ Family Apt. Building11226.0188 PARKSIDE AVENUEPARKSIDE AVENUENYCTA SUBWAYPARKSIDE COURTNaNNaNADDRESSBROOKLYNNaNNaNClosed04/02/2019 08:58:47 AMThe Department of Health and Mental Hygiene wi...03/03/2019 09:02:43 AM14 BROOKLYN3.050540e+09BROOKLYN994975.0177941.0ONLINEUnspecifiedBROOKLYNNaNNaNNaNNaNNaNNaNNaN40.655077-73.961347(40.655077133322926, -73.96134684659552)
44186389003/03/2019 12:00:00 AM03/11/2019 12:00:00 AMDOHMHDepartment of Health and Mental HygieneRodentMouse Sighting3+ Family Apt. Building10040.0578 WEST 193 STREETWEST 193 STREETNaNNaNNaNNaNLATLONGNEW YORKNaNNaNClosed04/02/2019 01:05:29 PMThe Department of Health and Mental Hygiene wi...03/11/2019 12:00:00 AMUnspecified MANHATTANNaNMANHATTAN1004145.0251323.0MOBILEUnspecifiedMANHATTANNaNNaNNaNNaNNaNNaNNaN40.856476-73.928081(40.856476014281995, -73.92808082554481)
54186385103/03/2019 12:00:00 AM03/11/2019 05:22:33 PMDOHMHDepartment of Health and Mental HygieneRodentMouse Sighting1-2 Family Dwelling11434.0134-23 159 STREET159 STREETNaNNaNNaNNaNLATLONGJAMAICANaNNaNClosed04/02/2019 05:38:50 PMThe Department of Health and Mental Hygiene wi...03/11/2019 05:22:33 PMUnspecified QUEENSNaNQUEENS1045981.0184107.0MOBILEUnspecifiedQUEENSNaNNaNNaNNaNNaNNaNNaN40.671793-73.777464(40.671792709238304, -73.77746402681198)
64186379803/03/2019 12:00:00 AM03/08/2019 12:00:00 AMDOHMHDepartment of Health and Mental HygieneRodentSigns of Rodents1-2 Family Dwelling11416.095-26 77 STREET77 STREETNaNNaNNaNNaNLATLONGOZONE PARKNaNNaNClosed04/02/2019 01:33:53 PMThe Department of Health and Mental Hygiene wi...03/08/2019 12:00:00 AMUnspecified QUEENSNaNQUEENS1022568.0187819.0MOBILEUnspecifiedQUEENSNaNNaNNaNNaNNaNNaNNaN40.682114-73.861845(40.682113596369, -73.86184498035452)
74186228603/03/2019 12:00:00 AM03/08/2019 04:38:51 PMDOHMHDepartment of Health and Mental HygieneRodentMouse Sighting3+ Family Apt. Building11415.083-57 118 STREET118 STREETNaNNaNNaNNaNLATLONGKEW GARDENSNaNNaNClosed04/02/2019 03:15:40 PMThe Department of Health and Mental Hygiene wi...03/08/2019 04:38:51 PMUnspecified QUEENSNaNQUEENS1030362.0196382.0MOBILEUnspecifiedQUEENSNaNNaNNaNNaNNaNNaNNaN40.705580-73.833685(40.70557983519105, -73.83368526501722)
84186226703/03/2019 12:00:00 AM03/11/2019 12:00:00 AMDOHMHDepartment of Health and Mental HygieneRodentMouse Sighting1-2 Family Dwelling11434.0134-27 159 STREET159 STREETNaNNaNNaNNaNLATLONGJAMAICANaNNaNClosed04/02/2019 05:41:58 PMThe Department of Health and Mental Hygiene wi...03/11/2019 12:00:00 AMUnspecified QUEENSNaNQUEENS1046002.0184073.0MOBILEUnspecifiedQUEENSNaNNaNNaNNaNNaNNaNNaN40.671699-73.777389(40.67169924070075, -73.7773886350757)
94186074103/03/2019 12:00:00 AMNaNDOHMHDepartment of Health and Mental HygieneRodentRat SightingCommercial Building11379.075-43 METROPOLITAN AVENUEMETROPOLITAN AVENUENaNNaNNaNNaNLATLONGMIDDLE VILLAGENaNNaNAssigned04/02/2019 01:38:24 PMThe Department of Health and Mental Hygiene wi...03/13/2019 12:12:29 PMUnspecified QUEENSNaNQUEENS1018607.0199180.0MOBILEUnspecifiedQUEENSNaNNaNNaNNaNNaNNaNNaN40.713313-73.876068(40.71331312485248, -73.87606833851066)
104186385603/03/2019 12:00:00 AM03/05/2019 03:31:26 PMDOHMHDepartment of Health and Mental HygieneRodentMouse Sighting3+ Family Apt. Building10470.0283 EAST 234 STREETEAST 234 STREETEAST 233 STREETKATONAH AVENUENaNNaNADDRESSBRONXNaNNaNClosed04/02/2019 10:14:00 AMThe Department of Health and Mental Hygiene wi...03/05/2019 03:31:26 PM12 BRONX2.033750e+09BRONX1020781.0266047.0ONLINEUnspecifiedBRONXNaNNaNNaNNaNNaNNaNNaN40.896836-73.867863(40.896835637278365, -73.86786251156862)
114186228703/03/2019 12:00:00 AM03/12/2019 12:00:00 AMDOHMHDepartment of Health and Mental HygieneRodentRat Sighting1-2 Family Dwelling10469.01000 EAST 216 STREETEAST 216 STREETNaNNaNNaNNaNLATLONGBRONXNaNNaNClosed04/02/2019 08:24:35 PMThe Department of Health and Mental Hygiene wi...03/05/2019 03:09:22 PMUnspecified BRONXNaNBRONX1024245.0259455.0MOBILEUnspecifiedBRONXNaNNaNNaNNaNNaNNaNNaN40.878728-73.855372(40.87872767338169, -73.85537215233431)
124186492203/03/2019 12:00:00 AM03/05/2019 12:00:00 AMDOHMHDepartment of Health and Mental HygieneRodentCondition Attracting Rodents1-2 Family Dwelling10303.0166 SIMONSON AVENUESIMONSON AVENUEHEUSDEN STREETWALKER STREETNaNNaNADDRESSSTATEN ISLANDNaNNaNClosed04/02/2019 09:35:32 AMThe Department of Health and Mental Hygiene wi...03/05/2019 12:00:00 AM01 STATEN ISLAND5.011900e+09STATEN ISLAND942033.0169818.0PHONEUnspecifiedSTATEN ISLANDNaNNaNNaNNaNNaNNaNNaN40.632687-74.152100(40.63268713998827, -74.15210008974351)
134186340903/03/2019 12:00:00 AM03/05/2019 12:00:00 AMDOHMHDepartment of Health and Mental HygieneRodentRat SightingOther (Explain Below)10470.0NaNNaNNaNNaNEAST 240 STREETKATONAH AVENUEINTERSECTIONBRONXNaNNaNClosed04/02/2019 11:00:21 AMThe Department of Health and Mental Hygiene wi...03/05/2019 12:00:00 AM12 BRONXNaNBRONX1020788.0267560.0PHONEUnspecifiedBRONXNaNNaNNaNNaNNaNNaNNaN40.900988-73.867829(40.90098830407419, -73.86782893416559)
144186335703/03/2019 12:00:00 AM03/07/2019 12:00:00 AMDOHMHDepartment of Health and Mental HygieneRodentRat Sighting3+ Family Apt. Building11233.0265 MARION STREETMARION STREETHOWARD AVENUESARATOGA AVENUENaNNaNADDRESSBROOKLYNNaNNaNClosed04/02/2019 04:24:59 AMThe Department of Health and Mental Hygiene wi...03/07/2019 12:00:00 AM03 BROOKLYN3.015140e+09BROOKLYN1006803.0187355.0PHONEUnspecifiedBROOKLYNNaNNaNNaNNaNNaNNaNNaN40.680894-73.918687(40.68089422924647, -73.91868697892829)
154186335603/03/2019 12:00:00 AM03/07/2019 12:00:00 AMDOHMHDepartment of Health and Mental HygieneRodentRat Sighting3+ Family Mixed Use Building10128.0178 EAST 88 STREETEAST 88 STREETLEXINGTON AVENUE3 AVENUENaNNaNADDRESSNEW YORKNaNNaNClosed04/02/2019 05:31:47 PMThe Department of Health and Mental Hygiene wi...03/07/2019 12:00:00 AM08 MANHATTAN1.015160e+09MANHATTAN997075.0223599.0ONLINEUnspecifiedMANHATTANNaNNaNNaNNaNNaNNaNNaN40.780395-73.953691(40.78039454839637, -73.95369140699738)
164186283603/03/2019 12:00:00 AM03/07/2019 12:00:00 AMDOHMHDepartment of Health and Mental HygieneRodentRat Sighting3+ Family Apt. Building10025.041 WEST 96 STREETWEST 96 STREETNaNNaNNaNNaNLATLONGNEW YORKNaNNaNClosed04/02/2019 08:44:30 PMThe Department of Health and Mental Hygiene wi...03/07/2019 12:00:00 AMUnspecified MANHATTANNaNMANHATTAN993563.0228067.0MOBILEUnspecifiedMANHATTANNaNNaNNaNNaNNaNNaNNaN40.792662-73.966366(40.79266241155883, -73.9663663634235)
174186155303/03/2019 12:00:00 AM03/07/2019 12:00:00 AMDOHMHDepartment of Health and Mental HygieneRodentMouse Sighting1-2 Family Dwelling11223.01660 WEST 2 STREETWEST 2 STREETNaNNaNNaNNaNLATLONGBROOKLYNNaNNaNClosed04/02/2019 10:48:13 AMThe Department of Health and Mental Hygiene wi...03/07/2019 12:00:00 AMUnspecified BROOKLYNNaNBROOKLYN990935.0160422.0MOBILEUnspecifiedBROOKLYNNaNNaNNaNNaNNaNNaNNaN40.606995-73.975924(40.60699515602938, -73.97592445441971)
184186138703/03/2019 12:00:00 AM03/06/2019 12:00:00 AMDOHMHDepartment of Health and Mental HygieneRodentCondition Attracting Rodents3+ Family Mixed Use Building10461.03555 BRUCKNER BOULEVARDBRUCKNER BOULEVARDROBERTS AVENUEBRUCKNER EXPWY WB EN BUHRE AVENaNNaNADDRESSBRONXNaNNaNClosed04/02/2019 06:26:22 AMThe Department of Health and Mental Hygiene wi...03/06/2019 12:00:00 AM10 BRONX2.041780e+09BRONX1031980.0248204.0ONLINEUnspecifiedBRONXNaNNaNNaNNaNNaNNaNNaN40.847809-73.827481(40.84780869783529, -73.82748144004533)
194186127403/03/2019 12:00:00 AM03/05/2019 12:00:00 AMDOHMHDepartment of Health and Mental HygieneRodentRat Sighting3+ Family Apt. Building11237.0167 STOCKHOLM STREETSTOCKHOLM STREETNaNNaNNaNNaNLATLONGBROOKLYNNaNNaNClosed04/02/2019 03:18:32 PMThe Department of Health and Mental Hygiene wi...03/05/2019 12:00:00 AMUnspecified BROOKLYNNaNBROOKLYN1005619.0194207.0MOBILEUnspecifiedBROOKLYNNaNNaNNaNNaNNaNNaNNaN40.699704-73.922934(40.69970432138696, -73.92293405882164)
204186074703/03/2019 12:00:00 AM03/07/2019 12:00:00 AMDOHMHDepartment of Health and Mental HygieneRodentRat Sighting3+ Family Apt. Building10025.0230 WEST 97 STREETWEST 97 STREETAMSTERDAM AVENUEBROADWAYNaNNaNADDRESSNEW YORKNaNNaNClosed04/02/2019 09:22:27 PMThe Department of Health and Mental Hygiene wi...03/07/2019 12:00:00 AM07 MANHATTAN1.018680e+09MANHATTAN992270.0228995.0ONLINEUnspecifiedMANHATTANNaNNaNNaNNaNNaNNaNNaN40.795211-73.971035(40.795210788509564, -73.97103488785471)
214186074503/03/2019 12:00:00 AM03/06/2019 12:00:00 AMDOHMHDepartment of Health and Mental HygieneRodentRat Sighting1-2 Family Dwelling10465.0210 SWINTON AVENUESWINTON AVENUECOLLIS PLACEHARDING AVENUENaNNaNADDRESSBRONXNaNNaNClosed04/02/2019 02:28:01 PMThe Department of Health and Mental Hygiene wi...03/06/2019 12:00:00 AM10 BRONX2.055920e+09BRONX1034322.0236305.0PHONEUnspecifiedBRONXNaNNaNNaNNaNNaNNaNNaN40.815136-73.819105(40.81513645959192, -73.81910519513468)
224186024703/03/2019 12:00:00 AM03/08/2019 12:00:00 AMDOHMHDepartment of Health and Mental HygieneRodentRat SightingCommercial Building11228.01454 86 STREET86 STREETNaNNaNNaNNaNLATLONGBROOKLYNNaNNaNClosed04/02/2019 02:52:15 AMThe Department of Health and Mental Hygiene wi...03/07/2019 12:00:00 AMUnspecified BROOKLYNNaNBROOKLYN981316.0162146.0MOBILEUnspecifiedBROOKLYNNaNNaNNaNNaNNaNNaNNaN40.611729-74.010567(40.61172921809639, -74.01056733871297)
234186024603/03/2019 12:00:00 AM03/08/2019 12:00:00 AMDOHMHDepartment of Health and Mental HygieneRodentRat Sighting3+ Family Apt. Building11220.0334 48 STREET48 STREETNaNNaNNaNNaNLATLONGBROOKLYNNaNNaNClosed04/02/2019 09:49:49 PMThe Department of Health and Mental Hygiene wi...03/07/2019 12:00:00 AMUnspecified BROOKLYNNaNBROOKLYN980681.0175426.0MOBILEUnspecifiedBROOKLYNNaNNaNNaNNaNNaNNaNNaN40.648180-74.012861(40.64817978132802, -74.0128614302328)
244186541603/03/2019 12:00:00 AM03/07/2019 12:00:00 AMDOHMHDepartment of Health and Mental HygieneRodentRat SightingConstruction Site11211.0653 METROPOLITAN AVENUEMETROPOLITAN AVENUELEONARD STREETMANHATTAN AVENUENaNNaNADDRESSBROOKLYNNaNNaNClosed04/02/2019 01:07:07 PMThe Department of Health and Mental Hygiene wi...03/05/2019 12:00:00 AM01 BROOKLYN3.027580e+09BROOKLYN998909.0199513.0ONLINEUnspecifiedBROOKLYNNaNNaNNaNNaNNaNNaNNaN40.714282-73.947122(40.71428169486935, -73.94712168904316)
254186515803/03/2019 12:00:00 AM03/04/2019 12:00:00 AMDOHMHDepartment of Health and Mental HygieneUnsanitary Animal Pvt PropertyDog1-2 Family Dwelling10469.0NaNNaNNaNNaNHERING AVENUEARNOW AVENUEINTERSECTIONBRONXNaNNaNClosed04/02/2019 01:55:05 PMThe Department of Health and Mental Hygiene wi...03/04/2019 12:00:00 AM11 BRONXNaNBRONX1024699.0255417.0UNKNOWNUnspecifiedBRONXNaNNaNNaNNaNNaNNaNNaN40.867643-73.853755(40.86764255014101, -73.85375480237843)
264186497603/03/2019 12:00:00 AMNaNDOHMHDepartment of Health and Mental HygieneRodentCondition Attracting Rodents3+ Family Apt. Building10459.0906 SIMPSON STREETSIMPSON STREETNaNNaNNaNNaNLATLONGBRONXNaNNaNAssigned04/02/2019 11:11:31 AMThe Department of Health and Mental Hygiene wi...03/03/2019 11:13:47 AMUnspecified BRONXNaNBRONX1013750.0238036.0MOBILEUnspecifiedBRONXNaNNaNNaNNaNNaNNaNNaN40.819980-73.893418(40.81998021496991, -73.8934178245375)
274186488803/03/2019 12:00:00 AM03/03/2019 12:00:00 AMDOHMHDepartment of Health and Mental HygieneRodentRat SightingCommercial Building11222.0711 MANHATTAN AVENUEMANHATTAN AVENUENaNNaNNaNNaNLATLONGBROOKLYNNaNNaNClosed04/02/2019 08:51:58 AMThe Department of Health and Mental Hygiene wi...03/03/2019 08:55:38 AMUnspecified BROOKLYNNaNBROOKLYN997498.0203674.0MOBILEUnspecifiedBROOKLYNNaNNaNNaNNaNNaNNaNNaN40.725705-73.952203(40.72570486120018, -73.95220329252537)
284186486003/03/2019 12:00:00 AMNaNDOHMHDepartment of Health and Mental HygieneRodentSigns of Rodents3+ Family Apt. Building11216.01059 BERGEN STREETBERGEN STREETROGERS AVENUENOSTRAND AVENUENaNNaNADDRESSBROOKLYNNaNNaNAssigned04/02/2019 09:38:28 PMThe Department of Health and Mental Hygiene wi...03/03/2019 12:00:00 AM08 BROOKLYN3.012120e+09BROOKLYN997785.0185628.0ONLINEUnspecifiedBROOKLYNNaNNaNNaNNaNNaNNaNNaN40.676172-73.951204(40.67617238875205, -73.95120410954186)
294186473103/03/2019 12:00:00 AM03/05/2019 12:00:00 AMDOHMHDepartment of Health and Mental HygieneUnsanitary Animal Pvt PropertyDog3+ Family Apartment Building10009.0277 AVENUE CAVENUE CEAST 16 STREETFDR DRIVE EXIT 7 NORTHBOUNDNaNNaNADDRESSNEW YORKNaNNaNClosed04/02/2019 08:51:47 PMThe Department of Health and Mental Hygiene wi...03/05/2019 12:00:00 AM06 MANHATTAN1.009720e+09MANHATTAN991271.0205239.0ONLINEUnspecifiedMANHATTANNaNNaNNaNNaNNaNNaNNaN40.730008-73.974668(40.73000753861665, -73.97466769783162)
..............................................................................................................................
125444187485403/05/2019 12:00:00 AM03/08/2019 12:00:00 AMDOHMHDepartment of Health and Mental HygieneRodentRat SightingOther (Explain Below)11222.075 BEADEL STREETBEADEL STREETMORGAN AVENUEVANDERVOORT AVENUENaNNaNADDRESSBROOKLYNNaNNaNClosed04/04/2019 02:32:42 PMThe Department of Health and Mental Hygiene wi...03/08/2019 12:00:00 AM01 BROOKLYN3.028350e+09BROOKLYN1001499.0202212.0PHONEUnspecifiedBROOKLYNNaNNaNNaNNaNNaNNaNNaN40.721685-73.937772(40.72168512943423, -73.93777206300011)
125454187432803/05/2019 12:00:00 AM03/08/2019 04:10:48 PMDOHMHDepartment of Health and Mental HygieneRodentMouse Sighting3+ Family Apt. Building11230.01219 AVENUE OAVENUE ONaNNaNNaNNaNLATLONGBROOKLYNNaNNaNClosed04/04/2019 12:08:26 AMThe Department of Health and Mental Hygiene wi...03/08/2019 04:10:48 PMUnspecified BROOKLYNNaNBROOKLYN994949.0162615.0MOBILEUnspecifiedBROOKLYNNaNNaNNaNNaNNaNNaNNaN40.613011-73.961465(40.6130105528666, -73.9614648499013)
125464188392903/05/2019 12:00:00 AMNaNDOHMHDepartment of Health and Mental HygieneRodentRat SightingOther (Explain Below)11221.01261 HANCOCK STREETHANCOCK STREETWILSON AVENUEKNICKERBOCKER AVENUENaNNaNADDRESSBROOKLYNNaNNaNAssigned04/04/2019 08:50:48 PMThe Department of Health and Mental Hygiene wi...03/05/2019 08:54:34 PM04 BROOKLYN3.033910e+09BROOKLYN1009062.0191734.0ONLINEUnspecifiedBROOKLYNNaNNaNNaNNaNNaNNaNNaN40.692908-73.910526(40.69290753072255, -73.91052621582875)
125474188348803/05/2019 12:00:00 AM03/05/2019 10:53:48 AMDOHMHDepartment of Health and Mental HygieneFood Poisoning1 or 2Restaurant/Bar/Deli/Bakery11364.078-43 SPRINGFIELD BOULEVARDSPRINGFIELD BOULEVARDKINGSBURY AVENUEUNION TURNPIKENaNNaNADDRESSOakland GardensNaNNaNClosed03/19/2019 09:26:57 AMThe Department of Health and Mental Hygiene wi...03/05/2019 09:51:24 AM11 QUEENS4.078420e+09QUEENS1054284.0207792.0PHONEUnspecifiedQUEENSNaNNaNNaNNaNNaNNaNNaN40.736740-73.747286(40.73674040052069, -73.74728611919126)
125484188348703/05/2019 12:00:00 AM03/05/2019 12:51:09 PMDOHMHDepartment of Health and Mental HygieneFood Poisoning1 or 2Restaurant/Bar/Deli/Bakery10021.01364 YORK AVENUEYORK AVENUEEAST 72 STREETEAST 73 STREETNaNNaNADDRESSNEW YORKNaNNaNClosed03/19/2019 12:28:34 PMThe Department of Health and Mental Hygiene wi...03/05/2019 12:51:09 PM08 MANHATTAN1.014840e+09MANHATTAN997154.0218826.0PHONEUnspecifiedMANHATTANNaNNaNNaNNaNNaNNaNNaN40.767294-73.953415(40.76729380057077, -73.95341531867508)
125494188279003/05/2019 12:00:00 AMNaNDOHMHDepartment of Health and Mental HygieneRodentRat SightingVacant Lot10455.0372 EAST 152 STREETEAST 152 STREETCOURTLANDT AVENUEMELROSE AVENUENaNNaNADDRESSBRONXNaNNaNAssigned04/04/2019 09:26:32 AMThe Department of Health and Mental Hygiene wi...03/05/2019 09:35:05 AM01 BRONX2.023980e+09BRONX1006966.0237495.0PHONEUnspecifiedBRONXNaNNaNNaNNaNNaNNaNNaN40.818515-73.917930(40.8185153736559, -73.91792992673089)
125504188270103/05/2019 12:00:00 AM03/05/2019 12:00:00 AMDOHMHDepartment of Health and Mental HygieneRodentRat Sighting3+ Family Apt. Building11237.0403 LINDEN STREETLINDEN STREETNaNNaNNaNNaNLATLONGBROOKLYNNaNNaNClosed04/04/2019 10:03:43 PMThe Department of Health and Mental Hygiene wi...03/05/2019 12:00:00 AMUnspecified BROOKLYNNaNBROOKLYN1008581.0194690.0MOBILEUnspecifiedBROOKLYNNaNNaNNaNNaNNaNNaNNaN40.701022-73.912250(40.70102239450479, -73.91225005572893)
125514188264703/05/2019 12:00:00 AMNaNDOHMHDepartment of Health and Mental HygieneRodentRat SightingConstruction Site10314.0NaNNaNNaNNaNWATERS AVENUEWOOLEY AVENUEINTERSECTIONSTATEN ISLANDNaNNaNAssigned04/04/2019 10:44:05 AMThe Department of Health and Mental Hygiene wi...03/05/2019 10:53:48 AM01 STATEN ISLANDNaNSTATEN ISLAND945538.0164376.0PHONEUnspecifiedSTATEN ISLANDNaNNaNNaNNaNNaNNaNNaN40.617766-74.139441(40.61776602115316, -74.13944103093016)
125524188232003/05/2019 12:00:00 AM03/05/2019 12:00:00 AMDOHMHDepartment of Health and Mental HygieneRodentSigns of RodentsCommercial Building10001.0282 8 AVENUE8 AVENUENaNNaNNaNNaNLATLONGNEW YORKNaNNaNClosed04/04/2019 08:22:34 PMThe Department of Health and Mental Hygiene wi...03/05/2019 08:26:22 PMUnspecified MANHATTANNaNMANHATTAN984931.0211055.0MOBILEUnspecifiedMANHATTANNaNNaNNaNNaNNaNNaNNaN40.745974-73.997542(40.74597377848978, -73.99754231136295)
125534188216503/05/2019 12:00:00 AMNaNDOHMHDepartment of Health and Mental HygieneUnsanitary Animal Pvt PropertyCat1-2 Family Dwelling11215.0587 7 STREET7 STREET8 AVENUEPROSPECT PARK WESTNaNNaNADDRESSBROOKLYNNaNNaNAssigned04/04/2019 11:43:03 AMThe Department of Health and Mental Hygiene wi...03/05/2019 11:56:03 AM06 BROOKLYN3.010870e+09BROOKLYN990626.0182064.0PHONEUnspecifiedBROOKLYNNaNNaNNaNNaNNaNNaNNaN40.666398-73.977017(40.66639805822617, -73.9770168456833)
125544188161003/05/2019 12:00:00 AM03/05/2019 12:00:00 AMDOHMHDepartment of Health and Mental HygieneRodentRat Sighting1-2 Family Dwelling11436.0119-19 146 STREET146 STREET119 AVENUE120 AVENUENaNNaNADDRESSJamaicaNaNNaNClosed04/04/2019 09:57:24 AMThe Department of Health and Mental Hygiene wi...03/05/2019 09:59:44 AM12 QUEENS4.120270e+09QUEENS1041457.0186462.0ONLINEUnspecifiedQUEENSNaNNaNNaNNaNNaNNaNNaN40.678287-73.793753(40.678287025790674, -73.79375268164732)
125554188119303/05/2019 12:00:00 AM03/05/2019 12:00:00 AMDOHMHDepartment of Health and Mental HygieneRodentCondition Attracting Rodents3+ Family Mixed Use Building10075.0220 EAST 78 STREETEAST 78 STREET3 AVENUE2 AVENUENaNNaNADDRESSNEW YORKNaNNaNClosed04/04/2019 04:00:11 PMThe Department of Health and Mental Hygiene wi...03/05/2019 04:10:30 PM08 MANHATTAN1.014320e+09MANHATTAN996120.0221020.0PHONEUnspecifiedMANHATTANNaNNaNNaNNaNNaNNaNNaN40.773317-73.957144(40.77331720716056, -73.95714428250285)
125564188056703/05/2019 12:00:00 AM03/05/2019 12:00:00 AMDOHMHDepartment of Health and Mental HygieneRodentMouse Sighting3+ Family Apt. Building10453.01997 DAVIDSON AVENUEDAVIDSON AVENUENaNNaNNaNNaNLATLONGBRONXNaNNaNClosed04/04/2019 10:59:53 AMThe Department of Health and Mental Hygiene wi...03/05/2019 11:08:29 AMUnspecified BRONXNaNBRONX1009247.0249966.0MOBILEUnspecifiedBRONXNaNNaNNaNNaNNaNNaNNaN40.852738-73.909642(40.852738484421245, -73.90964248803516)
125574187966303/05/2019 12:00:00 AM03/06/2019 09:52:30 AMDOHMHDepartment of Health and Mental HygieneFood Poisoning1 or 2Restaurant/Bar/Deli/Bakery10023.01900 BROADWAYBROADWAYWEST 63 STREETWEST 64 STREETNaNNaNADDRESSNEW YORKNaNNaNClosed03/19/2019 02:01:50 PMThe Department of Health and Mental Hygiene wi...03/06/2019 09:52:30 AM07 MANHATTAN1.011168e+09MANHATTAN989194.0220362.0ONLINEUnspecifiedMANHATTANNaNNaNNaNNaNNaNNaNNaN40.771518-73.982151(40.771517756240904, -73.98215055305542)
125584187961503/05/2019 12:00:00 AMNaNDOHMHDepartment of Health and Mental HygieneRodentCondition Attracting Rodents3+ Family Apt. Building11206.017 HART STREETHART STREETNOSTRAND AVENUEMARCY AVENUENaNNaNADDRESSBROOKLYNNaNNaNAssigned04/04/2019 09:19:48 PMThe Department of Health and Mental Hygiene wi...03/05/2019 12:00:00 AM03 BROOKLYN3.017660e+09BROOKLYN997821.0191728.0PHONEUnspecifiedBROOKLYNNaNNaNNaNNaNNaNNaNNaN40.692915-73.951062(40.692915438160504, -73.9510620376826)
125594187954203/05/2019 12:00:00 AMNaNDOHMHDepartment of Health and Mental HygieneRodentMouse Sighting3+ Family Apt. Building10022.0333 EAST 49 STREETEAST 49 STREETNaNNaNNaNNaNLATLONGNEW YORKNaNNaNAssigned04/04/2019 06:55:35 PMThe Department of Health and Mental Hygiene wi...03/05/2019 06:59:28 PMUnspecified MANHATTANNaNMANHATTAN993227.0213996.0MOBILEUnspecifiedMANHATTANNaNNaNNaNNaNNaNNaNNaN40.754042-73.967599(40.75404155064466, -73.96759861455782)
125604187914803/05/2019 12:00:00 AM03/05/2019 12:00:00 AMDOHMHDepartment of Health and Mental HygieneRodentRat Sighting3+ Family Apt. Building11226.0179 LINDEN BOULEVARDLINDEN BOULEVARDROGERS AVENUENOSTRAND AVENUENaNNaNADDRESSBROOKLYNNaNNaNClosed04/04/2019 10:59:14 AMThe Department of Health and Mental Hygiene wi...03/05/2019 11:08:32 AM17 BROOKLYN3.050850e+09BROOKLYN997612.0177018.0PHONEUnspecifiedBROOKLYNNaNNaNNaNNaNNaNNaNNaN40.652540-73.951845(40.65254011371671, -73.95184486671171)
125614187888703/05/2019 12:00:00 AMNaNDOHMHDepartment of Health and Mental HygieneRodentCondition Attracting RodentsCommercial Building10009.0178 AVENUE CAVENUE CEAST 11 STREETEAST 12 STREETNaNNaNADDRESSNEW YORKNaNNaNAssigned04/04/2019 04:07:31 PMThe Department of Health and Mental Hygiene wi...03/05/2019 04:15:38 PM03 MANHATTAN1.003820e+09MANHATTAN990621.0203981.0PHONEUnspecifiedMANHATTANNaNNaNNaNNaNNaNNaNNaN40.726555-73.977014(40.726555127702056, -73.97701413821252)
125624187742403/05/2019 12:00:00 AMNaNDOHMHDepartment of Health and Mental HygieneRodentRat SightingVacant Lot10304.0659 RICHMOND ROADRICHMOND ROADCONCORD PLACEDEKALB STREETNaNNaNADDRESSSTATEN ISLANDNaNNaNAssigned04/04/2019 01:32:08 PMThe Department of Health and Mental Hygiene wi...03/05/2019 01:35:45 PM01 STATEN ISLAND5.006310e+09STATEN ISLAND959508.0161718.0ONLINEUnspecifiedSTATEN ISLANDNaNNaNNaNNaNNaNNaNNaN40.610520-74.089111(40.6105203891322, -74.08911124898458)
125634187733003/05/2019 12:00:00 AM03/05/2019 12:00:00 AMDOHMHDepartment of Health and Mental HygieneRodentSigns of Rodents3+ Family Mixed Use Building10031.0611 WEST 148 STREETWEST 148 STREETBROADWAYRIVERSIDE DRIVENaNNaNADDRESSNEW YORKNaNNaNClosed04/04/2019 02:44:46 PMThe Department of Health and Mental Hygiene wi...03/05/2019 02:50:38 PM09 MANHATTAN1.020950e+09MANHATTAN998139.0241193.0ONLINEUnspecifiedMANHATTANNaNNaNNaNNaNNaNNaNNaN40.828684-73.949813(40.82868362208559, -73.94981311246337)
125644187729503/05/2019 12:00:00 AM03/06/2019 09:53:38 AMDOHMHDepartment of Health and Mental HygieneFood Poisoning1 or 2Restaurant/Bar/Deli/Bakery11208.0NaNNaNNEW LOTS AVENUECLEVELAND STREETCLEVELAND STREETNEW LOTS AVENUEADDRESSBROOKLYNNaNNaNClosed03/19/2019 03:57:08 PMThe Department of Health and Mental Hygiene wi...03/06/2019 09:53:38 AM05 BROOKLYNNaNBROOKLYN1016845.0182111.0PHONEUnspecifiedBROOKLYNNaNNaNNaNNaNNaNNaNNaN40.666469-73.882507(40.666469358702265, -73.8825067547414)
125654187706303/05/2019 12:00:00 AMNaNDOHMHDepartment of Health and Mental HygieneRodentMouse Sighting3+ Family Apt. Building10037.02063 MADISON AVENUEMADISON AVENUEEAST 130 STREETEAST 131 STREETNaNNaNADDRESSNEW YORKNaNNaNAssigned04/04/2019 11:53:30 PMThe Department of Health and Mental Hygiene wi...03/05/2019 12:00:00 AM11 MANHATTAN1.017550e+09MANHATTAN1001377.0234085.0PHONEUnspecifiedMANHATTANNaNNaNNaNNaNNaNNaNNaN40.809168-73.938131(40.80916848219286, -73.93813097988725)
125664187617403/05/2019 12:00:00 AMNaNDOHMHDepartment of Health and Mental HygieneRodentRat Sighting3+ Family Apt. Building10024.098 RIVERSIDE DRIVERIVERSIDE DRIVEWEST END AVENUERIVERSIDE DRIVENaNNaNADDRESSNEW YORKNaNNaNAssigned04/04/2019 08:46:57 AMThe Department of Health and Mental Hygiene wi...03/05/2019 08:54:02 AM07 MANHATTAN1.012440e+09MANHATTAN989564.0225870.0PHONEUnspecifiedMANHATTANNaNNaNNaNNaNNaNNaNNaN40.786636-73.980810(40.78663554636064, -73.98081037655064)
125674187617203/05/2019 12:00:00 AMNaNDOHMHDepartment of Health and Mental HygieneRodentRat Sighting1-2 Family Dwelling10473.0948 TAYLOR AVENUETAYLOR AVENUESTORY AVENUEBRUCKNER BOULEVARDNaNNaNADDRESSBRONXNaNNaNAssigned04/04/2019 11:40:54 AMThe Department of Health and Mental Hygiene wi...03/05/2019 11:48:47 AM09 BRONX2.036670e+09BRONX1021968.0239697.0PHONEUnspecifiedBRONXNaNNaNNaNNaNNaNNaNNaN40.824508-73.863717(40.824507917108185, -73.86371726574961)
125684187615003/05/2019 12:00:00 AMNaNDOHMHDepartment of Health and Mental HygieneRodentRat Sighting1-2 Family Dwelling11238.052A LEFFERTS PLACELEFFERTS PLACENaNNaNNaNNaNLATLONGBROOKLYNNaNNaNAssigned04/04/2019 10:23:52 PMThe Department of Health and Mental Hygiene wi...03/05/2019 12:00:00 AMUnspecified BROOKLYNNaNBROOKLYN994869.0187477.0MOBILEUnspecifiedBROOKLYNNaNNaNNaNNaNNaNNaNNaN40.681251-73.961714(40.68125145292855, -73.96171385183325)
125694187585503/05/2019 12:00:00 AMNaNDOHMHDepartment of Health and Mental HygieneRodentMouse Sighting3+ Family Apt. Building10458.02746 DECATUR AVENUEDECATUR AVENUENaNNaNNaNNaNLATLONGBRONXNaNNaNAssigned04/04/2019 07:03:45 AMThe Department of Health and Mental Hygiene wi...03/05/2019 07:08:27 AMUnspecified BRONXNaNBRONX1015342.0254653.0MOBILEUnspecifiedBRONXNaNNaNNaNNaNNaNNaNNaN40.865584-73.887589(40.865583521525394, -73.88758896310604)
125704187535303/05/2019 12:00:00 AM03/05/2019 12:00:00 AMDOHMHDepartment of Health and Mental HygieneRodentSigns of Rodents3+ Family Apt. Building11374.061-25 97 STREET97 STREETNaNNaNNaNNaNLATLONGREGO PARKNaNNaNClosed04/04/2019 07:34:19 AMThe Department of Health and Mental Hygiene wi...03/05/2019 07:37:51 AMUnspecified QUEENSNaNQUEENS1022543.0206593.0MOBILEUnspecifiedQUEENSNaNNaNNaNNaNNaNNaNNaN40.733644-73.861828(40.73364382925023, -73.86182834745202)
125714187481703/05/2019 12:00:00 AM03/05/2019 12:00:00 AMDOHMHDepartment of Health and Mental HygieneRodentRat Sighting3+ Family Apt. Building10027.0528 WEST 123 STREETWEST 123 STREETNaNNaNNaNNaNLATLONGNEW YORKNaNNaNClosed04/04/2019 04:32:56 PMThe Department of Health and Mental Hygiene wi...03/05/2019 04:36:31 PMUnspecified MANHATTANNaNMANHATTAN995541.0234968.0MOBILEUnspecifiedMANHATTANNaNNaNNaNNaNNaNNaNNaN40.811601-73.959211(40.811601457751294, -73.95921126818385)
125724187480303/05/2019 12:00:00 AM03/05/2019 12:00:00 AMDOHMHDepartment of Health and Mental HygieneRodentCondition Attracting Rodents3+ Family Apt. Building11226.0150 EAST 19 STREETEAST 19 STREETNaNNaNNaNNaNLATLONGBROOKLYNNaNNaNClosed04/04/2019 11:44:46 PMThe Department of Health and Mental Hygiene wi...03/05/2019 12:00:00 AMUnspecified BROOKLYNNaNBROOKLYN994869.0174566.0MOBILEUnspecifiedBROOKLYNNaNNaNNaNNaNNaNNaNNaN40.645814-73.961734(40.6458136201676, -73.96173418656669)
125734187084703/05/2019 12:00:00 AMNaNDOHMHDepartment of Health and Mental HygieneRodentMouse Sighting3+ Family Apt. Building11693.0314 BEACH 86 STREETBEACH 86 STREETROCKAWAY FREEWAYBEACH CHANNEL DRIVENaNNaNADDRESSFar RockawayNaNNaNAssigned04/04/2019 12:33:03 AMThe Department of Health and Mental Hygiene wi...03/05/2019 12:00:00 AM14 QUEENS4.161170e+09QUEENS1036608.0154091.0PHONEUnspecifiedQUEENSNaNNaNNaNNaNNaNNaNNaN40.589466-73.811486(40.589465724073776, -73.81148579209827)
\n", "

12574 rows × 41 columns

\n", "
" ], "text/plain": [ " Unique Key Created Date Closed Date Agency \\\n", "0 41864921 03/03/2019 12:00:00 AM 03/08/2019 12:00:00 AM DOHMH \n", "1 41907255 03/03/2019 12:00:00 AM 03/08/2019 12:05:00 PM DEP \n", "2 41865062 03/03/2019 12:00:00 AM 03/12/2019 04:39:55 PM DOHMH \n", "3 41864615 03/03/2019 12:00:00 AM 03/03/2019 12:00:00 AM DOHMH \n", "4 41863890 03/03/2019 12:00:00 AM 03/11/2019 12:00:00 AM DOHMH \n", "5 41863851 03/03/2019 12:00:00 AM 03/11/2019 05:22:33 PM DOHMH \n", "6 41863798 03/03/2019 12:00:00 AM 03/08/2019 12:00:00 AM DOHMH \n", "7 41862286 03/03/2019 12:00:00 AM 03/08/2019 04:38:51 PM DOHMH \n", "8 41862267 03/03/2019 12:00:00 AM 03/11/2019 12:00:00 AM DOHMH \n", "9 41860741 03/03/2019 12:00:00 AM NaN DOHMH \n", "10 41863856 03/03/2019 12:00:00 AM 03/05/2019 03:31:26 PM DOHMH \n", "11 41862287 03/03/2019 12:00:00 AM 03/12/2019 12:00:00 AM DOHMH \n", "12 41864922 03/03/2019 12:00:00 AM 03/05/2019 12:00:00 AM DOHMH \n", "13 41863409 03/03/2019 12:00:00 AM 03/05/2019 12:00:00 AM DOHMH \n", "14 41863357 03/03/2019 12:00:00 AM 03/07/2019 12:00:00 AM DOHMH \n", "15 41863356 03/03/2019 12:00:00 AM 03/07/2019 12:00:00 AM DOHMH \n", "16 41862836 03/03/2019 12:00:00 AM 03/07/2019 12:00:00 AM DOHMH \n", "17 41861553 03/03/2019 12:00:00 AM 03/07/2019 12:00:00 AM DOHMH \n", "18 41861387 03/03/2019 12:00:00 AM 03/06/2019 12:00:00 AM DOHMH \n", "19 41861274 03/03/2019 12:00:00 AM 03/05/2019 12:00:00 AM DOHMH \n", "20 41860747 03/03/2019 12:00:00 AM 03/07/2019 12:00:00 AM DOHMH \n", "21 41860745 03/03/2019 12:00:00 AM 03/06/2019 12:00:00 AM DOHMH \n", "22 41860247 03/03/2019 12:00:00 AM 03/08/2019 12:00:00 AM DOHMH \n", "23 41860246 03/03/2019 12:00:00 AM 03/08/2019 12:00:00 AM DOHMH \n", "24 41865416 03/03/2019 12:00:00 AM 03/07/2019 12:00:00 AM DOHMH \n", "25 41865158 03/03/2019 12:00:00 AM 03/04/2019 12:00:00 AM DOHMH \n", "26 41864976 03/03/2019 12:00:00 AM NaN DOHMH \n", "27 41864888 03/03/2019 12:00:00 AM 03/03/2019 12:00:00 AM DOHMH \n", "28 41864860 03/03/2019 12:00:00 AM NaN DOHMH \n", "29 41864731 03/03/2019 12:00:00 AM 03/05/2019 12:00:00 AM DOHMH \n", "... ... ... ... ... \n", "12544 41874854 03/05/2019 12:00:00 AM 03/08/2019 12:00:00 AM DOHMH \n", "12545 41874328 03/05/2019 12:00:00 AM 03/08/2019 04:10:48 PM DOHMH \n", "12546 41883929 03/05/2019 12:00:00 AM NaN DOHMH \n", "12547 41883488 03/05/2019 12:00:00 AM 03/05/2019 10:53:48 AM DOHMH \n", "12548 41883487 03/05/2019 12:00:00 AM 03/05/2019 12:51:09 PM DOHMH \n", "12549 41882790 03/05/2019 12:00:00 AM NaN DOHMH \n", "12550 41882701 03/05/2019 12:00:00 AM 03/05/2019 12:00:00 AM DOHMH \n", "12551 41882647 03/05/2019 12:00:00 AM NaN DOHMH \n", "12552 41882320 03/05/2019 12:00:00 AM 03/05/2019 12:00:00 AM DOHMH \n", "12553 41882165 03/05/2019 12:00:00 AM NaN DOHMH \n", "12554 41881610 03/05/2019 12:00:00 AM 03/05/2019 12:00:00 AM DOHMH \n", "12555 41881193 03/05/2019 12:00:00 AM 03/05/2019 12:00:00 AM DOHMH \n", "12556 41880567 03/05/2019 12:00:00 AM 03/05/2019 12:00:00 AM DOHMH \n", "12557 41879663 03/05/2019 12:00:00 AM 03/06/2019 09:52:30 AM DOHMH \n", "12558 41879615 03/05/2019 12:00:00 AM NaN DOHMH \n", "12559 41879542 03/05/2019 12:00:00 AM NaN DOHMH \n", "12560 41879148 03/05/2019 12:00:00 AM 03/05/2019 12:00:00 AM DOHMH \n", "12561 41878887 03/05/2019 12:00:00 AM NaN DOHMH \n", "12562 41877424 03/05/2019 12:00:00 AM NaN DOHMH \n", "12563 41877330 03/05/2019 12:00:00 AM 03/05/2019 12:00:00 AM DOHMH \n", "12564 41877295 03/05/2019 12:00:00 AM 03/06/2019 09:53:38 AM DOHMH \n", "12565 41877063 03/05/2019 12:00:00 AM NaN DOHMH \n", "12566 41876174 03/05/2019 12:00:00 AM NaN DOHMH \n", "12567 41876172 03/05/2019 12:00:00 AM NaN DOHMH \n", "12568 41876150 03/05/2019 12:00:00 AM NaN DOHMH \n", "12569 41875855 03/05/2019 12:00:00 AM NaN DOHMH \n", "12570 41875353 03/05/2019 12:00:00 AM 03/05/2019 12:00:00 AM DOHMH \n", "12571 41874817 03/05/2019 12:00:00 AM 03/05/2019 12:00:00 AM DOHMH \n", "12572 41874803 03/05/2019 12:00:00 AM 03/05/2019 12:00:00 AM DOHMH \n", "12573 41870847 03/05/2019 12:00:00 AM NaN DOHMH \n", "\n", " Agency Name \\\n", "0 Department of Health and Mental Hygiene \n", "1 Department of Environmental Protection \n", "2 Department of Health and Mental Hygiene \n", "3 Department of Health and Mental Hygiene \n", "4 Department of Health and Mental Hygiene \n", "5 Department of Health and Mental Hygiene \n", "6 Department of Health and Mental Hygiene \n", "7 Department of Health and Mental Hygiene \n", "8 Department of Health and Mental Hygiene \n", "9 Department of Health and Mental Hygiene \n", "10 Department of Health and Mental Hygiene \n", "11 Department of Health and Mental Hygiene \n", "12 Department of Health and Mental Hygiene \n", "13 Department of Health and Mental Hygiene \n", "14 Department of Health and Mental Hygiene \n", "15 Department of Health and Mental Hygiene \n", "16 Department of Health and Mental Hygiene \n", "17 Department of Health and Mental Hygiene \n", "18 Department of Health and Mental Hygiene \n", "19 Department of Health and Mental Hygiene \n", "20 Department of Health and Mental Hygiene \n", "21 Department of Health and Mental Hygiene \n", "22 Department of Health and Mental Hygiene \n", "23 Department of Health and Mental Hygiene \n", "24 Department of Health and Mental Hygiene \n", "25 Department of Health and Mental Hygiene \n", "26 Department of Health and Mental Hygiene \n", "27 Department of Health and Mental Hygiene \n", "28 Department of Health and Mental Hygiene \n", "29 Department of Health and Mental Hygiene \n", "... ... \n", "12544 Department of Health and Mental Hygiene \n", "12545 Department of Health and Mental Hygiene \n", "12546 Department of Health and Mental Hygiene \n", "12547 Department of Health and Mental Hygiene \n", "12548 Department of Health and Mental Hygiene \n", "12549 Department of Health and Mental Hygiene \n", "12550 Department of Health and Mental Hygiene \n", "12551 Department of Health and Mental Hygiene \n", "12552 Department of Health and Mental Hygiene \n", "12553 Department of Health and Mental Hygiene \n", "12554 Department of Health and Mental Hygiene \n", "12555 Department of Health and Mental Hygiene \n", "12556 Department of Health and Mental Hygiene \n", "12557 Department of Health and Mental Hygiene \n", "12558 Department of Health and Mental Hygiene \n", "12559 Department of Health and Mental Hygiene \n", "12560 Department of Health and Mental Hygiene \n", "12561 Department of Health and Mental Hygiene \n", "12562 Department of Health and Mental Hygiene \n", "12563 Department of Health and Mental Hygiene \n", "12564 Department of Health and Mental Hygiene \n", "12565 Department of Health and Mental Hygiene \n", "12566 Department of Health and Mental Hygiene \n", "12567 Department of Health and Mental Hygiene \n", "12568 Department of Health and Mental Hygiene \n", "12569 Department of Health and Mental Hygiene \n", "12570 Department of Health and Mental Hygiene \n", "12571 Department of Health and Mental Hygiene \n", "12572 Department of Health and Mental Hygiene \n", "12573 Department of Health and Mental Hygiene \n", "\n", " Complaint Type Descriptor \\\n", "0 Rodent Condition Attracting Rodents \n", "1 Asbestos Asbestos Complaint (B1) \n", "2 Rodent Mouse Sighting \n", "3 Rodent Mouse Sighting \n", "4 Rodent Mouse Sighting \n", "5 Rodent Mouse Sighting \n", "6 Rodent Signs of Rodents \n", "7 Rodent Mouse Sighting \n", "8 Rodent Mouse Sighting \n", "9 Rodent Rat Sighting \n", "10 Rodent Mouse Sighting \n", "11 Rodent Rat Sighting \n", "12 Rodent Condition Attracting Rodents \n", "13 Rodent Rat Sighting \n", "14 Rodent Rat Sighting \n", "15 Rodent Rat Sighting \n", "16 Rodent Rat Sighting \n", "17 Rodent Mouse Sighting \n", "18 Rodent Condition Attracting Rodents \n", "19 Rodent Rat Sighting \n", "20 Rodent Rat Sighting \n", "21 Rodent Rat Sighting \n", "22 Rodent Rat Sighting \n", "23 Rodent Rat Sighting \n", "24 Rodent Rat Sighting \n", "25 Unsanitary Animal Pvt Property Dog \n", "26 Rodent Condition Attracting Rodents \n", "27 Rodent Rat Sighting \n", "28 Rodent Signs of Rodents \n", "29 Unsanitary Animal Pvt Property Dog \n", "... ... ... \n", "12544 Rodent Rat Sighting \n", "12545 Rodent Mouse Sighting \n", "12546 Rodent Rat Sighting \n", "12547 Food Poisoning 1 or 2 \n", "12548 Food Poisoning 1 or 2 \n", "12549 Rodent Rat Sighting \n", "12550 Rodent Rat Sighting \n", "12551 Rodent Rat Sighting \n", "12552 Rodent Signs of Rodents \n", "12553 Unsanitary Animal Pvt Property Cat \n", "12554 Rodent Rat Sighting \n", "12555 Rodent Condition Attracting Rodents \n", "12556 Rodent Mouse Sighting \n", "12557 Food Poisoning 1 or 2 \n", "12558 Rodent Condition Attracting Rodents \n", "12559 Rodent Mouse Sighting \n", "12560 Rodent Rat Sighting \n", "12561 Rodent Condition Attracting Rodents \n", "12562 Rodent Rat Sighting \n", "12563 Rodent Signs of Rodents \n", "12564 Food Poisoning 1 or 2 \n", "12565 Rodent Mouse Sighting \n", "12566 Rodent Rat Sighting \n", "12567 Rodent Rat Sighting \n", "12568 Rodent Rat Sighting \n", "12569 Rodent Mouse Sighting \n", "12570 Rodent Signs of Rodents \n", "12571 Rodent Rat Sighting \n", "12572 Rodent Condition Attracting Rodents \n", "12573 Rodent Mouse Sighting \n", "\n", " Location Type Incident Zip \\\n", "0 Commercial Building 10314.0 \n", "1 NaN 10017.0 \n", "2 3+ Family Apt. Building 11225.0 \n", "3 3+ Family Apt. Building 11226.0 \n", "4 3+ Family Apt. Building 10040.0 \n", "5 1-2 Family Dwelling 11434.0 \n", "6 1-2 Family Dwelling 11416.0 \n", "7 3+ Family Apt. Building 11415.0 \n", "8 1-2 Family Dwelling 11434.0 \n", "9 Commercial Building 11379.0 \n", "10 3+ Family Apt. Building 10470.0 \n", "11 1-2 Family Dwelling 10469.0 \n", "12 1-2 Family Dwelling 10303.0 \n", "13 Other (Explain Below) 10470.0 \n", "14 3+ Family Apt. Building 11233.0 \n", "15 3+ Family Mixed Use Building 10128.0 \n", "16 3+ Family Apt. Building 10025.0 \n", "17 1-2 Family Dwelling 11223.0 \n", "18 3+ Family Mixed Use Building 10461.0 \n", "19 3+ Family Apt. Building 11237.0 \n", "20 3+ Family Apt. Building 10025.0 \n", "21 1-2 Family Dwelling 10465.0 \n", "22 Commercial Building 11228.0 \n", "23 3+ Family Apt. Building 11220.0 \n", "24 Construction Site 11211.0 \n", "25 1-2 Family Dwelling 10469.0 \n", "26 3+ Family Apt. Building 10459.0 \n", "27 Commercial Building 11222.0 \n", "28 3+ Family Apt. Building 11216.0 \n", "29 3+ Family Apartment Building 10009.0 \n", "... ... ... \n", "12544 Other (Explain Below) 11222.0 \n", "12545 3+ Family Apt. Building 11230.0 \n", "12546 Other (Explain Below) 11221.0 \n", "12547 Restaurant/Bar/Deli/Bakery 11364.0 \n", "12548 Restaurant/Bar/Deli/Bakery 10021.0 \n", "12549 Vacant Lot 10455.0 \n", "12550 3+ Family Apt. Building 11237.0 \n", "12551 Construction Site 10314.0 \n", "12552 Commercial Building 10001.0 \n", "12553 1-2 Family Dwelling 11215.0 \n", "12554 1-2 Family Dwelling 11436.0 \n", "12555 3+ Family Mixed Use Building 10075.0 \n", "12556 3+ Family Apt. Building 10453.0 \n", "12557 Restaurant/Bar/Deli/Bakery 10023.0 \n", "12558 3+ Family Apt. Building 11206.0 \n", "12559 3+ Family Apt. Building 10022.0 \n", "12560 3+ Family Apt. Building 11226.0 \n", "12561 Commercial Building 10009.0 \n", "12562 Vacant Lot 10304.0 \n", "12563 3+ Family Mixed Use Building 10031.0 \n", "12564 Restaurant/Bar/Deli/Bakery 11208.0 \n", "12565 3+ Family Apt. Building 10037.0 \n", "12566 3+ Family Apt. Building 10024.0 \n", "12567 1-2 Family Dwelling 10473.0 \n", "12568 1-2 Family Dwelling 11238.0 \n", "12569 3+ Family Apt. Building 10458.0 \n", "12570 3+ Family Apt. Building 11374.0 \n", "12571 3+ Family Apt. Building 10027.0 \n", "12572 3+ Family Apt. Building 11226.0 \n", "12573 3+ Family Apt. Building 11693.0 \n", "\n", " Incident Address Street Name Cross Street 1 \\\n", "0 2216 VICTORY BOULEVARD VICTORY BOULEVARD CARMEL AVENUE \n", "1 155 EAST 47 STREET EAST 47 STREET LEXINGTON AVE \n", "2 390 EASTERN PARKWAY EASTERN PARKWAY FRANKLIN AVENUE \n", "3 188 PARKSIDE AVENUE PARKSIDE AVENUE NYCTA SUBWAY \n", "4 578 WEST 193 STREET WEST 193 STREET NaN \n", "5 134-23 159 STREET 159 STREET NaN \n", "6 95-26 77 STREET 77 STREET NaN \n", "7 83-57 118 STREET 118 STREET NaN \n", "8 134-27 159 STREET 159 STREET NaN \n", "9 75-43 METROPOLITAN AVENUE METROPOLITAN AVENUE NaN \n", "10 283 EAST 234 STREET EAST 234 STREET EAST 233 STREET \n", "11 1000 EAST 216 STREET EAST 216 STREET NaN \n", "12 166 SIMONSON AVENUE SIMONSON AVENUE HEUSDEN STREET \n", "13 NaN NaN NaN \n", "14 265 MARION STREET MARION STREET HOWARD AVENUE \n", "15 178 EAST 88 STREET EAST 88 STREET LEXINGTON AVENUE \n", "16 41 WEST 96 STREET WEST 96 STREET NaN \n", "17 1660 WEST 2 STREET WEST 2 STREET NaN \n", "18 3555 BRUCKNER BOULEVARD BRUCKNER BOULEVARD ROBERTS AVENUE \n", "19 167 STOCKHOLM STREET STOCKHOLM STREET NaN \n", "20 230 WEST 97 STREET WEST 97 STREET AMSTERDAM AVENUE \n", "21 210 SWINTON AVENUE SWINTON AVENUE COLLIS PLACE \n", "22 1454 86 STREET 86 STREET NaN \n", "23 334 48 STREET 48 STREET NaN \n", "24 653 METROPOLITAN AVENUE METROPOLITAN AVENUE LEONARD STREET \n", "25 NaN NaN NaN \n", "26 906 SIMPSON STREET SIMPSON STREET NaN \n", "27 711 MANHATTAN AVENUE MANHATTAN AVENUE NaN \n", "28 1059 BERGEN STREET BERGEN STREET ROGERS AVENUE \n", "29 277 AVENUE C AVENUE C EAST 16 STREET \n", "... ... ... ... \n", "12544 75 BEADEL STREET BEADEL STREET MORGAN AVENUE \n", "12545 1219 AVENUE O AVENUE O NaN \n", "12546 1261 HANCOCK STREET HANCOCK STREET WILSON AVENUE \n", "12547 78-43 SPRINGFIELD BOULEVARD SPRINGFIELD BOULEVARD KINGSBURY AVENUE \n", "12548 1364 YORK AVENUE YORK AVENUE EAST 72 STREET \n", "12549 372 EAST 152 STREET EAST 152 STREET COURTLANDT AVENUE \n", "12550 403 LINDEN STREET LINDEN STREET NaN \n", "12551 NaN NaN NaN \n", "12552 282 8 AVENUE 8 AVENUE NaN \n", "12553 587 7 STREET 7 STREET 8 AVENUE \n", "12554 119-19 146 STREET 146 STREET 119 AVENUE \n", "12555 220 EAST 78 STREET EAST 78 STREET 3 AVENUE \n", "12556 1997 DAVIDSON AVENUE DAVIDSON AVENUE NaN \n", "12557 1900 BROADWAY BROADWAY WEST 63 STREET \n", "12558 17 HART STREET HART STREET NOSTRAND AVENUE \n", "12559 333 EAST 49 STREET EAST 49 STREET NaN \n", "12560 179 LINDEN BOULEVARD LINDEN BOULEVARD ROGERS AVENUE \n", "12561 178 AVENUE C AVENUE C EAST 11 STREET \n", "12562 659 RICHMOND ROAD RICHMOND ROAD CONCORD PLACE \n", "12563 611 WEST 148 STREET WEST 148 STREET BROADWAY \n", "12564 NaN NaN NEW LOTS AVENUE \n", "12565 2063 MADISON AVENUE MADISON AVENUE EAST 130 STREET \n", "12566 98 RIVERSIDE DRIVE RIVERSIDE DRIVE WEST END AVENUE \n", "12567 948 TAYLOR AVENUE TAYLOR AVENUE STORY AVENUE \n", "12568 52A LEFFERTS PLACE LEFFERTS PLACE NaN \n", "12569 2746 DECATUR AVENUE DECATUR AVENUE NaN \n", "12570 61-25 97 STREET 97 STREET NaN \n", "12571 528 WEST 123 STREET WEST 123 STREET NaN \n", "12572 150 EAST 19 STREET EAST 19 STREET NaN \n", "12573 314 BEACH 86 STREET BEACH 86 STREET ROCKAWAY FREEWAY \n", "\n", " Cross Street 2 Intersection Street 1 \\\n", "0 O'CONNOR AVENUE NaN \n", "1 3 AVE NaN \n", "2 BEDFORD AVENUE NaN \n", "3 PARKSIDE COURT NaN \n", "4 NaN NaN \n", "5 NaN NaN \n", "6 NaN NaN \n", "7 NaN NaN \n", "8 NaN NaN \n", "9 NaN NaN \n", "10 KATONAH AVENUE NaN \n", "11 NaN NaN \n", "12 WALKER STREET NaN \n", "13 NaN EAST 240 STREET \n", "14 SARATOGA AVENUE NaN \n", "15 3 AVENUE NaN \n", "16 NaN NaN \n", "17 NaN NaN \n", "18 BRUCKNER EXPWY WB EN BUHRE AVE NaN \n", "19 NaN NaN \n", "20 BROADWAY NaN \n", "21 HARDING AVENUE NaN \n", "22 NaN NaN \n", "23 NaN NaN \n", "24 MANHATTAN AVENUE NaN \n", "25 NaN HERING AVENUE \n", "26 NaN NaN \n", "27 NaN NaN \n", "28 NOSTRAND AVENUE NaN \n", "29 FDR DRIVE EXIT 7 NORTHBOUND NaN \n", "... ... ... \n", "12544 VANDERVOORT AVENUE NaN \n", "12545 NaN NaN \n", "12546 KNICKERBOCKER AVENUE NaN \n", "12547 UNION TURNPIKE NaN \n", "12548 EAST 73 STREET NaN \n", "12549 MELROSE AVENUE NaN \n", "12550 NaN NaN \n", "12551 NaN WATERS AVENUE \n", "12552 NaN NaN \n", "12553 PROSPECT PARK WEST NaN \n", "12554 120 AVENUE NaN \n", "12555 2 AVENUE NaN \n", "12556 NaN NaN \n", "12557 WEST 64 STREET NaN \n", "12558 MARCY AVENUE NaN \n", "12559 NaN NaN \n", "12560 NOSTRAND AVENUE NaN \n", "12561 EAST 12 STREET NaN \n", "12562 DEKALB STREET NaN \n", "12563 RIVERSIDE DRIVE NaN \n", "12564 CLEVELAND STREET CLEVELAND STREET \n", "12565 EAST 131 STREET NaN \n", "12566 RIVERSIDE DRIVE NaN \n", "12567 BRUCKNER BOULEVARD NaN \n", "12568 NaN NaN \n", "12569 NaN NaN \n", "12570 NaN NaN \n", "12571 NaN NaN \n", "12572 NaN NaN \n", "12573 BEACH CHANNEL DRIVE NaN \n", "\n", " Intersection Street 2 Address Type City Landmark \\\n", "0 NaN ADDRESS STATEN ISLAND NaN \n", "1 NaN ADDRESS NEW YORK NaN \n", "2 NaN ADDRESS BROOKLYN NaN \n", "3 NaN ADDRESS BROOKLYN NaN \n", "4 NaN LATLONG NEW YORK NaN \n", "5 NaN LATLONG JAMAICA NaN \n", "6 NaN LATLONG OZONE PARK NaN \n", "7 NaN LATLONG KEW GARDENS NaN \n", "8 NaN LATLONG JAMAICA NaN \n", "9 NaN LATLONG MIDDLE VILLAGE NaN \n", "10 NaN ADDRESS BRONX NaN \n", "11 NaN LATLONG BRONX NaN \n", "12 NaN ADDRESS STATEN ISLAND NaN \n", "13 KATONAH AVENUE INTERSECTION BRONX NaN \n", "14 NaN ADDRESS BROOKLYN NaN \n", "15 NaN ADDRESS NEW YORK NaN \n", "16 NaN LATLONG NEW YORK NaN \n", "17 NaN LATLONG BROOKLYN NaN \n", "18 NaN ADDRESS BRONX NaN \n", "19 NaN LATLONG BROOKLYN NaN \n", "20 NaN ADDRESS NEW YORK NaN \n", "21 NaN ADDRESS BRONX NaN \n", "22 NaN LATLONG BROOKLYN NaN \n", "23 NaN LATLONG BROOKLYN NaN \n", "24 NaN ADDRESS BROOKLYN NaN \n", "25 ARNOW AVENUE INTERSECTION BRONX NaN \n", "26 NaN LATLONG BRONX NaN \n", "27 NaN LATLONG BROOKLYN NaN \n", "28 NaN ADDRESS BROOKLYN NaN \n", "29 NaN ADDRESS NEW YORK NaN \n", "... ... ... ... ... \n", "12544 NaN ADDRESS BROOKLYN NaN \n", "12545 NaN LATLONG BROOKLYN NaN \n", "12546 NaN ADDRESS BROOKLYN NaN \n", "12547 NaN ADDRESS Oakland Gardens NaN \n", "12548 NaN ADDRESS NEW YORK NaN \n", "12549 NaN ADDRESS BRONX NaN \n", "12550 NaN LATLONG BROOKLYN NaN \n", "12551 WOOLEY AVENUE INTERSECTION STATEN ISLAND NaN \n", "12552 NaN LATLONG NEW YORK NaN \n", "12553 NaN ADDRESS BROOKLYN NaN \n", "12554 NaN ADDRESS Jamaica NaN \n", "12555 NaN ADDRESS NEW YORK NaN \n", "12556 NaN LATLONG BRONX NaN \n", "12557 NaN ADDRESS NEW YORK NaN \n", "12558 NaN ADDRESS BROOKLYN NaN \n", "12559 NaN LATLONG NEW YORK NaN \n", "12560 NaN ADDRESS BROOKLYN NaN \n", "12561 NaN ADDRESS NEW YORK NaN \n", "12562 NaN ADDRESS STATEN ISLAND NaN \n", "12563 NaN ADDRESS NEW YORK NaN \n", "12564 NEW LOTS AVENUE ADDRESS BROOKLYN NaN \n", "12565 NaN ADDRESS NEW YORK NaN \n", "12566 NaN ADDRESS NEW YORK NaN \n", "12567 NaN ADDRESS BRONX NaN \n", "12568 NaN LATLONG BROOKLYN NaN \n", "12569 NaN LATLONG BRONX NaN \n", "12570 NaN LATLONG REGO PARK NaN \n", "12571 NaN LATLONG NEW YORK NaN \n", "12572 NaN LATLONG BROOKLYN NaN \n", "12573 NaN ADDRESS Far Rockaway NaN \n", "\n", " Facility Type Status Due Date \\\n", "0 NaN Closed 04/02/2019 09:27:17 AM \n", "1 NaN Closed NaN \n", "2 NaN Closed 04/02/2019 03:44:08 PM \n", "3 NaN Closed 04/02/2019 08:58:47 AM \n", "4 NaN Closed 04/02/2019 01:05:29 PM \n", "5 NaN Closed 04/02/2019 05:38:50 PM \n", "6 NaN Closed 04/02/2019 01:33:53 PM \n", "7 NaN Closed 04/02/2019 03:15:40 PM \n", "8 NaN Closed 04/02/2019 05:41:58 PM \n", "9 NaN Assigned 04/02/2019 01:38:24 PM \n", "10 NaN Closed 04/02/2019 10:14:00 AM \n", "11 NaN Closed 04/02/2019 08:24:35 PM \n", "12 NaN Closed 04/02/2019 09:35:32 AM \n", "13 NaN Closed 04/02/2019 11:00:21 AM \n", "14 NaN Closed 04/02/2019 04:24:59 AM \n", "15 NaN Closed 04/02/2019 05:31:47 PM \n", "16 NaN Closed 04/02/2019 08:44:30 PM \n", "17 NaN Closed 04/02/2019 10:48:13 AM \n", "18 NaN Closed 04/02/2019 06:26:22 AM \n", "19 NaN Closed 04/02/2019 03:18:32 PM \n", "20 NaN Closed 04/02/2019 09:22:27 PM \n", "21 NaN Closed 04/02/2019 02:28:01 PM \n", "22 NaN Closed 04/02/2019 02:52:15 AM \n", "23 NaN Closed 04/02/2019 09:49:49 PM \n", "24 NaN Closed 04/02/2019 01:07:07 PM \n", "25 NaN Closed 04/02/2019 01:55:05 PM \n", "26 NaN Assigned 04/02/2019 11:11:31 AM \n", "27 NaN Closed 04/02/2019 08:51:58 AM \n", "28 NaN Assigned 04/02/2019 09:38:28 PM \n", "29 NaN Closed 04/02/2019 08:51:47 PM \n", "... ... ... ... \n", "12544 NaN Closed 04/04/2019 02:32:42 PM \n", "12545 NaN Closed 04/04/2019 12:08:26 AM \n", "12546 NaN Assigned 04/04/2019 08:50:48 PM \n", "12547 NaN Closed 03/19/2019 09:26:57 AM \n", "12548 NaN Closed 03/19/2019 12:28:34 PM \n", "12549 NaN Assigned 04/04/2019 09:26:32 AM \n", "12550 NaN Closed 04/04/2019 10:03:43 PM \n", "12551 NaN Assigned 04/04/2019 10:44:05 AM \n", "12552 NaN Closed 04/04/2019 08:22:34 PM \n", "12553 NaN Assigned 04/04/2019 11:43:03 AM \n", "12554 NaN Closed 04/04/2019 09:57:24 AM \n", "12555 NaN Closed 04/04/2019 04:00:11 PM \n", "12556 NaN Closed 04/04/2019 10:59:53 AM \n", "12557 NaN Closed 03/19/2019 02:01:50 PM \n", "12558 NaN Assigned 04/04/2019 09:19:48 PM \n", "12559 NaN Assigned 04/04/2019 06:55:35 PM \n", "12560 NaN Closed 04/04/2019 10:59:14 AM \n", "12561 NaN Assigned 04/04/2019 04:07:31 PM \n", "12562 NaN Assigned 04/04/2019 01:32:08 PM \n", "12563 NaN Closed 04/04/2019 02:44:46 PM \n", "12564 NaN Closed 03/19/2019 03:57:08 PM \n", "12565 NaN Assigned 04/04/2019 11:53:30 PM \n", "12566 NaN Assigned 04/04/2019 08:46:57 AM \n", "12567 NaN Assigned 04/04/2019 11:40:54 AM \n", "12568 NaN Assigned 04/04/2019 10:23:52 PM \n", "12569 NaN Assigned 04/04/2019 07:03:45 AM \n", "12570 NaN Closed 04/04/2019 07:34:19 AM \n", "12571 NaN Closed 04/04/2019 04:32:56 PM \n", "12572 NaN Closed 04/04/2019 11:44:46 PM \n", "12573 NaN Assigned 04/04/2019 12:33:03 AM \n", "\n", " Resolution Description \\\n", "0 The Department of Health and Mental Hygiene wi... \n", "1 The Department of Environmental Protection inv... \n", "2 The Department of Health and Mental Hygiene wi... \n", "3 The Department of Health and Mental Hygiene wi... \n", "4 The Department of Health and Mental Hygiene wi... \n", "5 The Department of Health and Mental Hygiene wi... \n", "6 The Department of Health and Mental Hygiene wi... \n", "7 The Department of Health and Mental Hygiene wi... \n", "8 The Department of Health and Mental Hygiene wi... \n", "9 The Department of Health and Mental Hygiene wi... \n", "10 The Department of Health and Mental Hygiene wi... \n", "11 The Department of Health and Mental Hygiene wi... \n", "12 The Department of Health and Mental Hygiene wi... \n", "13 The Department of Health and Mental Hygiene wi... \n", "14 The Department of Health and Mental Hygiene wi... \n", "15 The Department of Health and Mental Hygiene wi... \n", "16 The Department of Health and Mental Hygiene wi... \n", "17 The Department of Health and Mental Hygiene wi... \n", "18 The Department of Health and Mental Hygiene wi... \n", "19 The Department of Health and Mental Hygiene wi... \n", "20 The Department of Health and Mental Hygiene wi... \n", "21 The Department of Health and Mental Hygiene wi... \n", "22 The Department of Health and Mental Hygiene wi... \n", "23 The Department of Health and Mental Hygiene wi... \n", "24 The Department of Health and Mental Hygiene wi... \n", "25 The Department of Health and Mental Hygiene wi... \n", "26 The Department of Health and Mental Hygiene wi... \n", "27 The Department of Health and Mental Hygiene wi... \n", "28 The Department of Health and Mental Hygiene wi... \n", "29 The Department of Health and Mental Hygiene wi... \n", "... ... \n", "12544 The Department of Health and Mental Hygiene wi... \n", "12545 The Department of Health and Mental Hygiene wi... \n", "12546 The Department of Health and Mental Hygiene wi... \n", "12547 The Department of Health and Mental Hygiene wi... \n", "12548 The Department of Health and Mental Hygiene wi... \n", "12549 The Department of Health and Mental Hygiene wi... \n", "12550 The Department of Health and Mental Hygiene wi... \n", "12551 The Department of Health and Mental Hygiene wi... \n", "12552 The Department of Health and Mental Hygiene wi... \n", "12553 The Department of Health and Mental Hygiene wi... \n", "12554 The Department of Health and Mental Hygiene wi... \n", "12555 The Department of Health and Mental Hygiene wi... \n", "12556 The Department of Health and Mental Hygiene wi... \n", "12557 The Department of Health and Mental Hygiene wi... \n", "12558 The Department of Health and Mental Hygiene wi... \n", "12559 The Department of Health and Mental Hygiene wi... \n", "12560 The Department of Health and Mental Hygiene wi... \n", "12561 The Department of Health and Mental Hygiene wi... \n", "12562 The Department of Health and Mental Hygiene wi... \n", "12563 The Department of Health and Mental Hygiene wi... \n", "12564 The Department of Health and Mental Hygiene wi... \n", "12565 The Department of Health and Mental Hygiene wi... \n", "12566 The Department of Health and Mental Hygiene wi... \n", "12567 The Department of Health and Mental Hygiene wi... \n", "12568 The Department of Health and Mental Hygiene wi... \n", "12569 The Department of Health and Mental Hygiene wi... \n", "12570 The Department of Health and Mental Hygiene wi... \n", "12571 The Department of Health and Mental Hygiene wi... \n", "12572 The Department of Health and Mental Hygiene wi... \n", "12573 The Department of Health and Mental Hygiene wi... \n", "\n", " Resolution Action Updated Date Community Board BBL \\\n", "0 03/08/2019 12:00:00 AM 01 STATEN ISLAND 5.007350e+09 \n", "1 03/08/2019 12:05:00 PM 06 MANHATTAN 1.013020e+09 \n", "2 03/12/2019 04:39:55 PM 09 BROOKLYN 3.012668e+09 \n", "3 03/03/2019 09:02:43 AM 14 BROOKLYN 3.050540e+09 \n", "4 03/11/2019 12:00:00 AM Unspecified MANHATTAN NaN \n", "5 03/11/2019 05:22:33 PM Unspecified QUEENS NaN \n", "6 03/08/2019 12:00:00 AM Unspecified QUEENS NaN \n", "7 03/08/2019 04:38:51 PM Unspecified QUEENS NaN \n", "8 03/11/2019 12:00:00 AM Unspecified QUEENS NaN \n", "9 03/13/2019 12:12:29 PM Unspecified QUEENS NaN \n", "10 03/05/2019 03:31:26 PM 12 BRONX 2.033750e+09 \n", "11 03/05/2019 03:09:22 PM Unspecified BRONX NaN \n", "12 03/05/2019 12:00:00 AM 01 STATEN ISLAND 5.011900e+09 \n", "13 03/05/2019 12:00:00 AM 12 BRONX NaN \n", "14 03/07/2019 12:00:00 AM 03 BROOKLYN 3.015140e+09 \n", "15 03/07/2019 12:00:00 AM 08 MANHATTAN 1.015160e+09 \n", "16 03/07/2019 12:00:00 AM Unspecified MANHATTAN NaN \n", "17 03/07/2019 12:00:00 AM Unspecified BROOKLYN NaN \n", "18 03/06/2019 12:00:00 AM 10 BRONX 2.041780e+09 \n", "19 03/05/2019 12:00:00 AM Unspecified BROOKLYN NaN \n", "20 03/07/2019 12:00:00 AM 07 MANHATTAN 1.018680e+09 \n", "21 03/06/2019 12:00:00 AM 10 BRONX 2.055920e+09 \n", "22 03/07/2019 12:00:00 AM Unspecified BROOKLYN NaN \n", "23 03/07/2019 12:00:00 AM Unspecified BROOKLYN NaN \n", "24 03/05/2019 12:00:00 AM 01 BROOKLYN 3.027580e+09 \n", "25 03/04/2019 12:00:00 AM 11 BRONX NaN \n", "26 03/03/2019 11:13:47 AM Unspecified BRONX NaN \n", "27 03/03/2019 08:55:38 AM Unspecified BROOKLYN NaN \n", "28 03/03/2019 12:00:00 AM 08 BROOKLYN 3.012120e+09 \n", "29 03/05/2019 12:00:00 AM 06 MANHATTAN 1.009720e+09 \n", "... ... ... ... \n", "12544 03/08/2019 12:00:00 AM 01 BROOKLYN 3.028350e+09 \n", "12545 03/08/2019 04:10:48 PM Unspecified BROOKLYN NaN \n", "12546 03/05/2019 08:54:34 PM 04 BROOKLYN 3.033910e+09 \n", "12547 03/05/2019 09:51:24 AM 11 QUEENS 4.078420e+09 \n", "12548 03/05/2019 12:51:09 PM 08 MANHATTAN 1.014840e+09 \n", "12549 03/05/2019 09:35:05 AM 01 BRONX 2.023980e+09 \n", "12550 03/05/2019 12:00:00 AM Unspecified BROOKLYN NaN \n", "12551 03/05/2019 10:53:48 AM 01 STATEN ISLAND NaN \n", "12552 03/05/2019 08:26:22 PM Unspecified MANHATTAN NaN \n", "12553 03/05/2019 11:56:03 AM 06 BROOKLYN 3.010870e+09 \n", "12554 03/05/2019 09:59:44 AM 12 QUEENS 4.120270e+09 \n", "12555 03/05/2019 04:10:30 PM 08 MANHATTAN 1.014320e+09 \n", "12556 03/05/2019 11:08:29 AM Unspecified BRONX NaN \n", "12557 03/06/2019 09:52:30 AM 07 MANHATTAN 1.011168e+09 \n", "12558 03/05/2019 12:00:00 AM 03 BROOKLYN 3.017660e+09 \n", "12559 03/05/2019 06:59:28 PM Unspecified MANHATTAN NaN \n", "12560 03/05/2019 11:08:32 AM 17 BROOKLYN 3.050850e+09 \n", "12561 03/05/2019 04:15:38 PM 03 MANHATTAN 1.003820e+09 \n", "12562 03/05/2019 01:35:45 PM 01 STATEN ISLAND 5.006310e+09 \n", "12563 03/05/2019 02:50:38 PM 09 MANHATTAN 1.020950e+09 \n", "12564 03/06/2019 09:53:38 AM 05 BROOKLYN NaN \n", "12565 03/05/2019 12:00:00 AM 11 MANHATTAN 1.017550e+09 \n", "12566 03/05/2019 08:54:02 AM 07 MANHATTAN 1.012440e+09 \n", "12567 03/05/2019 11:48:47 AM 09 BRONX 2.036670e+09 \n", "12568 03/05/2019 12:00:00 AM Unspecified BROOKLYN NaN \n", "12569 03/05/2019 07:08:27 AM Unspecified BRONX NaN \n", "12570 03/05/2019 07:37:51 AM Unspecified QUEENS NaN \n", "12571 03/05/2019 04:36:31 PM Unspecified MANHATTAN NaN \n", "12572 03/05/2019 12:00:00 AM Unspecified BROOKLYN NaN \n", "12573 03/05/2019 12:00:00 AM 14 QUEENS 4.161170e+09 \n", "\n", " Borough X Coordinate (State Plane) Y Coordinate (State Plane) \\\n", "0 STATEN ISLAND 946124.0 162287.0 \n", "1 MANHATTAN 991730.0 214097.0 \n", "2 BROOKLYN 996465.0 183471.0 \n", "3 BROOKLYN 994975.0 177941.0 \n", "4 MANHATTAN 1004145.0 251323.0 \n", "5 QUEENS 1045981.0 184107.0 \n", "6 QUEENS 1022568.0 187819.0 \n", "7 QUEENS 1030362.0 196382.0 \n", "8 QUEENS 1046002.0 184073.0 \n", "9 QUEENS 1018607.0 199180.0 \n", "10 BRONX 1020781.0 266047.0 \n", "11 BRONX 1024245.0 259455.0 \n", "12 STATEN ISLAND 942033.0 169818.0 \n", "13 BRONX 1020788.0 267560.0 \n", "14 BROOKLYN 1006803.0 187355.0 \n", "15 MANHATTAN 997075.0 223599.0 \n", "16 MANHATTAN 993563.0 228067.0 \n", "17 BROOKLYN 990935.0 160422.0 \n", "18 BRONX 1031980.0 248204.0 \n", "19 BROOKLYN 1005619.0 194207.0 \n", "20 MANHATTAN 992270.0 228995.0 \n", "21 BRONX 1034322.0 236305.0 \n", "22 BROOKLYN 981316.0 162146.0 \n", "23 BROOKLYN 980681.0 175426.0 \n", "24 BROOKLYN 998909.0 199513.0 \n", "25 BRONX 1024699.0 255417.0 \n", "26 BRONX 1013750.0 238036.0 \n", "27 BROOKLYN 997498.0 203674.0 \n", "28 BROOKLYN 997785.0 185628.0 \n", "29 MANHATTAN 991271.0 205239.0 \n", "... ... ... ... \n", "12544 BROOKLYN 1001499.0 202212.0 \n", "12545 BROOKLYN 994949.0 162615.0 \n", "12546 BROOKLYN 1009062.0 191734.0 \n", "12547 QUEENS 1054284.0 207792.0 \n", "12548 MANHATTAN 997154.0 218826.0 \n", "12549 BRONX 1006966.0 237495.0 \n", "12550 BROOKLYN 1008581.0 194690.0 \n", "12551 STATEN ISLAND 945538.0 164376.0 \n", "12552 MANHATTAN 984931.0 211055.0 \n", "12553 BROOKLYN 990626.0 182064.0 \n", "12554 QUEENS 1041457.0 186462.0 \n", "12555 MANHATTAN 996120.0 221020.0 \n", "12556 BRONX 1009247.0 249966.0 \n", "12557 MANHATTAN 989194.0 220362.0 \n", "12558 BROOKLYN 997821.0 191728.0 \n", "12559 MANHATTAN 993227.0 213996.0 \n", "12560 BROOKLYN 997612.0 177018.0 \n", "12561 MANHATTAN 990621.0 203981.0 \n", "12562 STATEN ISLAND 959508.0 161718.0 \n", "12563 MANHATTAN 998139.0 241193.0 \n", "12564 BROOKLYN 1016845.0 182111.0 \n", "12565 MANHATTAN 1001377.0 234085.0 \n", "12566 MANHATTAN 989564.0 225870.0 \n", "12567 BRONX 1021968.0 239697.0 \n", "12568 BROOKLYN 994869.0 187477.0 \n", "12569 BRONX 1015342.0 254653.0 \n", "12570 QUEENS 1022543.0 206593.0 \n", "12571 MANHATTAN 995541.0 234968.0 \n", "12572 BROOKLYN 994869.0 174566.0 \n", "12573 QUEENS 1036608.0 154091.0 \n", "\n", " Open Data Channel Type Park Facility Name Park Borough Vehicle Type \\\n", "0 ONLINE Unspecified STATEN ISLAND NaN \n", "1 UNKNOWN Unspecified MANHATTAN NaN \n", "2 PHONE Unspecified BROOKLYN NaN \n", "3 ONLINE Unspecified BROOKLYN NaN \n", "4 MOBILE Unspecified MANHATTAN NaN \n", "5 MOBILE Unspecified QUEENS NaN \n", "6 MOBILE Unspecified QUEENS NaN \n", "7 MOBILE Unspecified QUEENS NaN \n", "8 MOBILE Unspecified QUEENS NaN \n", "9 MOBILE Unspecified QUEENS NaN \n", "10 ONLINE Unspecified BRONX NaN \n", "11 MOBILE Unspecified BRONX NaN \n", "12 PHONE Unspecified STATEN ISLAND NaN \n", "13 PHONE Unspecified BRONX NaN \n", "14 PHONE Unspecified BROOKLYN NaN \n", "15 ONLINE Unspecified MANHATTAN NaN \n", "16 MOBILE Unspecified MANHATTAN NaN \n", "17 MOBILE Unspecified BROOKLYN NaN \n", "18 ONLINE Unspecified BRONX NaN \n", "19 MOBILE Unspecified BROOKLYN NaN \n", "20 ONLINE Unspecified MANHATTAN NaN \n", "21 PHONE Unspecified BRONX NaN \n", "22 MOBILE Unspecified BROOKLYN NaN \n", "23 MOBILE Unspecified BROOKLYN NaN \n", "24 ONLINE Unspecified BROOKLYN NaN \n", "25 UNKNOWN Unspecified BRONX NaN \n", "26 MOBILE Unspecified BRONX NaN \n", "27 MOBILE Unspecified BROOKLYN NaN \n", "28 ONLINE Unspecified BROOKLYN NaN \n", "29 ONLINE Unspecified MANHATTAN NaN \n", "... ... ... ... ... \n", "12544 PHONE Unspecified BROOKLYN NaN \n", "12545 MOBILE Unspecified BROOKLYN NaN \n", "12546 ONLINE Unspecified BROOKLYN NaN \n", "12547 PHONE Unspecified QUEENS NaN \n", "12548 PHONE Unspecified MANHATTAN NaN \n", "12549 PHONE Unspecified BRONX NaN \n", "12550 MOBILE Unspecified BROOKLYN NaN \n", "12551 PHONE Unspecified STATEN ISLAND NaN \n", "12552 MOBILE Unspecified MANHATTAN NaN \n", "12553 PHONE Unspecified BROOKLYN NaN \n", "12554 ONLINE Unspecified QUEENS NaN \n", "12555 PHONE Unspecified MANHATTAN NaN \n", "12556 MOBILE Unspecified BRONX NaN \n", "12557 ONLINE Unspecified MANHATTAN NaN \n", "12558 PHONE Unspecified BROOKLYN NaN \n", "12559 MOBILE Unspecified MANHATTAN NaN \n", "12560 PHONE Unspecified BROOKLYN NaN \n", "12561 PHONE Unspecified MANHATTAN NaN \n", "12562 ONLINE Unspecified STATEN ISLAND NaN \n", "12563 ONLINE Unspecified MANHATTAN NaN \n", "12564 PHONE Unspecified BROOKLYN NaN \n", "12565 PHONE Unspecified MANHATTAN NaN \n", "12566 PHONE Unspecified MANHATTAN NaN \n", "12567 PHONE Unspecified BRONX NaN \n", "12568 MOBILE Unspecified BROOKLYN NaN \n", "12569 MOBILE Unspecified BRONX NaN \n", "12570 MOBILE Unspecified QUEENS NaN \n", "12571 MOBILE Unspecified MANHATTAN NaN \n", "12572 MOBILE Unspecified BROOKLYN NaN \n", "12573 PHONE Unspecified QUEENS NaN \n", "\n", " Taxi Company Borough Taxi Pick Up Location Bridge Highway Name \\\n", "0 NaN NaN NaN \n", "1 NaN NaN NaN \n", "2 NaN NaN NaN \n", "3 NaN NaN NaN \n", "4 NaN NaN NaN \n", "5 NaN NaN NaN \n", "6 NaN NaN NaN \n", "7 NaN NaN NaN \n", "8 NaN NaN NaN \n", "9 NaN NaN NaN \n", "10 NaN NaN NaN \n", "11 NaN NaN NaN \n", "12 NaN NaN NaN \n", "13 NaN NaN NaN \n", "14 NaN NaN NaN \n", "15 NaN NaN NaN \n", "16 NaN NaN NaN \n", "17 NaN NaN NaN \n", "18 NaN NaN NaN \n", "19 NaN NaN NaN \n", "20 NaN NaN NaN \n", "21 NaN NaN NaN \n", "22 NaN NaN NaN \n", "23 NaN NaN NaN \n", "24 NaN NaN NaN \n", "25 NaN NaN NaN \n", "26 NaN NaN NaN \n", "27 NaN NaN NaN \n", "28 NaN NaN NaN \n", "29 NaN NaN NaN \n", "... ... ... ... \n", "12544 NaN NaN NaN \n", "12545 NaN NaN NaN \n", "12546 NaN NaN NaN \n", "12547 NaN NaN NaN \n", "12548 NaN NaN NaN \n", "12549 NaN NaN NaN \n", "12550 NaN NaN NaN \n", "12551 NaN NaN NaN \n", "12552 NaN NaN NaN \n", "12553 NaN NaN NaN \n", "12554 NaN NaN NaN \n", "12555 NaN NaN NaN \n", "12556 NaN NaN NaN \n", "12557 NaN NaN NaN \n", "12558 NaN NaN NaN \n", "12559 NaN NaN NaN \n", "12560 NaN NaN NaN \n", "12561 NaN NaN NaN \n", "12562 NaN NaN NaN \n", "12563 NaN NaN NaN \n", "12564 NaN NaN NaN \n", "12565 NaN NaN NaN \n", "12566 NaN NaN NaN \n", "12567 NaN NaN NaN \n", "12568 NaN NaN NaN \n", "12569 NaN NaN NaN \n", "12570 NaN NaN NaN \n", "12571 NaN NaN NaN \n", "12572 NaN NaN NaN \n", "12573 NaN NaN NaN \n", "\n", " Bridge Highway Direction Road Ramp Bridge Highway Segment Latitude \\\n", "0 NaN NaN NaN 40.612035 \n", "1 NaN NaN NaN 40.754320 \n", "2 NaN NaN NaN 40.670254 \n", "3 NaN NaN NaN 40.655077 \n", "4 NaN NaN NaN 40.856476 \n", "5 NaN NaN NaN 40.671793 \n", "6 NaN NaN NaN 40.682114 \n", "7 NaN NaN NaN 40.705580 \n", "8 NaN NaN NaN 40.671699 \n", "9 NaN NaN NaN 40.713313 \n", "10 NaN NaN NaN 40.896836 \n", "11 NaN NaN NaN 40.878728 \n", "12 NaN NaN NaN 40.632687 \n", "13 NaN NaN NaN 40.900988 \n", "14 NaN NaN NaN 40.680894 \n", "15 NaN NaN NaN 40.780395 \n", "16 NaN NaN NaN 40.792662 \n", "17 NaN NaN NaN 40.606995 \n", "18 NaN NaN NaN 40.847809 \n", "19 NaN NaN NaN 40.699704 \n", "20 NaN NaN NaN 40.795211 \n", "21 NaN NaN NaN 40.815136 \n", "22 NaN NaN NaN 40.611729 \n", "23 NaN NaN NaN 40.648180 \n", "24 NaN NaN NaN 40.714282 \n", "25 NaN NaN NaN 40.867643 \n", "26 NaN NaN NaN 40.819980 \n", "27 NaN NaN NaN 40.725705 \n", "28 NaN NaN NaN 40.676172 \n", "29 NaN NaN NaN 40.730008 \n", "... ... ... ... ... \n", "12544 NaN NaN NaN 40.721685 \n", "12545 NaN NaN NaN 40.613011 \n", "12546 NaN NaN NaN 40.692908 \n", "12547 NaN NaN NaN 40.736740 \n", "12548 NaN NaN NaN 40.767294 \n", "12549 NaN NaN NaN 40.818515 \n", "12550 NaN NaN NaN 40.701022 \n", "12551 NaN NaN NaN 40.617766 \n", "12552 NaN NaN NaN 40.745974 \n", "12553 NaN NaN NaN 40.666398 \n", "12554 NaN NaN NaN 40.678287 \n", "12555 NaN NaN NaN 40.773317 \n", "12556 NaN NaN NaN 40.852738 \n", "12557 NaN NaN NaN 40.771518 \n", "12558 NaN NaN NaN 40.692915 \n", "12559 NaN NaN NaN 40.754042 \n", "12560 NaN NaN NaN 40.652540 \n", "12561 NaN NaN NaN 40.726555 \n", "12562 NaN NaN NaN 40.610520 \n", "12563 NaN NaN NaN 40.828684 \n", "12564 NaN NaN NaN 40.666469 \n", "12565 NaN NaN NaN 40.809168 \n", "12566 NaN NaN NaN 40.786636 \n", "12567 NaN NaN NaN 40.824508 \n", "12568 NaN NaN NaN 40.681251 \n", "12569 NaN NaN NaN 40.865584 \n", "12570 NaN NaN NaN 40.733644 \n", "12571 NaN NaN NaN 40.811601 \n", "12572 NaN NaN NaN 40.645814 \n", "12573 NaN NaN NaN 40.589466 \n", "\n", " Longitude Location \n", "0 -74.137318 (40.612034696062125, -74.13731846061239) \n", "1 -73.973002 (40.754320163093986, -73.97300174054661) \n", "2 -73.955967 (40.670253828660485, -73.95596683374993) \n", "3 -73.961347 (40.655077133322926, -73.96134684659552) \n", "4 -73.928081 (40.856476014281995, -73.92808082554481) \n", "5 -73.777464 (40.671792709238304, -73.77746402681198) \n", "6 -73.861845 (40.682113596369, -73.86184498035452) \n", "7 -73.833685 (40.70557983519105, -73.83368526501722) \n", "8 -73.777389 (40.67169924070075, -73.7773886350757) \n", "9 -73.876068 (40.71331312485248, -73.87606833851066) \n", "10 -73.867863 (40.896835637278365, -73.86786251156862) \n", "11 -73.855372 (40.87872767338169, -73.85537215233431) \n", "12 -74.152100 (40.63268713998827, -74.15210008974351) \n", "13 -73.867829 (40.90098830407419, -73.86782893416559) \n", "14 -73.918687 (40.68089422924647, -73.91868697892829) \n", "15 -73.953691 (40.78039454839637, -73.95369140699738) \n", "16 -73.966366 (40.79266241155883, -73.9663663634235) \n", "17 -73.975924 (40.60699515602938, -73.97592445441971) \n", "18 -73.827481 (40.84780869783529, -73.82748144004533) \n", "19 -73.922934 (40.69970432138696, -73.92293405882164) \n", "20 -73.971035 (40.795210788509564, -73.97103488785471) \n", "21 -73.819105 (40.81513645959192, -73.81910519513468) \n", "22 -74.010567 (40.61172921809639, -74.01056733871297) \n", "23 -74.012861 (40.64817978132802, -74.0128614302328) \n", "24 -73.947122 (40.71428169486935, -73.94712168904316) \n", "25 -73.853755 (40.86764255014101, -73.85375480237843) \n", "26 -73.893418 (40.81998021496991, -73.8934178245375) \n", "27 -73.952203 (40.72570486120018, -73.95220329252537) \n", "28 -73.951204 (40.67617238875205, -73.95120410954186) \n", "29 -73.974668 (40.73000753861665, -73.97466769783162) \n", "... ... ... \n", "12544 -73.937772 (40.72168512943423, -73.93777206300011) \n", "12545 -73.961465 (40.6130105528666, -73.9614648499013) \n", "12546 -73.910526 (40.69290753072255, -73.91052621582875) \n", "12547 -73.747286 (40.73674040052069, -73.74728611919126) \n", "12548 -73.953415 (40.76729380057077, -73.95341531867508) \n", "12549 -73.917930 (40.8185153736559, -73.91792992673089) \n", "12550 -73.912250 (40.70102239450479, -73.91225005572893) \n", "12551 -74.139441 (40.61776602115316, -74.13944103093016) \n", "12552 -73.997542 (40.74597377848978, -73.99754231136295) \n", "12553 -73.977017 (40.66639805822617, -73.9770168456833) \n", "12554 -73.793753 (40.678287025790674, -73.79375268164732) \n", "12555 -73.957144 (40.77331720716056, -73.95714428250285) \n", "12556 -73.909642 (40.852738484421245, -73.90964248803516) \n", "12557 -73.982151 (40.771517756240904, -73.98215055305542) \n", "12558 -73.951062 (40.692915438160504, -73.9510620376826) \n", "12559 -73.967599 (40.75404155064466, -73.96759861455782) \n", "12560 -73.951845 (40.65254011371671, -73.95184486671171) \n", "12561 -73.977014 (40.726555127702056, -73.97701413821252) \n", "12562 -74.089111 (40.6105203891322, -74.08911124898458) \n", "12563 -73.949813 (40.82868362208559, -73.94981311246337) \n", "12564 -73.882507 (40.666469358702265, -73.8825067547414) \n", "12565 -73.938131 (40.80916848219286, -73.93813097988725) \n", "12566 -73.980810 (40.78663554636064, -73.98081037655064) \n", "12567 -73.863717 (40.824507917108185, -73.86371726574961) \n", "12568 -73.961714 (40.68125145292855, -73.96171385183325) \n", "12569 -73.887589 (40.865583521525394, -73.88758896310604) \n", "12570 -73.861828 (40.73364382925023, -73.86182834745202) \n", "12571 -73.959211 (40.811601457751294, -73.95921126818385) \n", "12572 -73.961734 (40.6458136201676, -73.96173418656669) \n", "12573 -73.811486 (40.589465724073776, -73.81148579209827) \n", "\n", "[12574 rows x 41 columns]" ] }, "execution_count": 6, "metadata": {}, "output_type": "execute_result" } ], "source": [ "calls = pd.read_csv(\"Mar3_4_2019_311_Service_Requests.csv\")\n", "calls" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "Display the `calls` dataframe to make sure it was loaded into memory correctly. If you want to see all column, run `pd.set_option(\"display.max_columns\",None)` first." ] }, { "cell_type": "code", "execution_count": null, "metadata": { "collapsed": true }, "outputs": [], "source": [] }, { "cell_type": "markdown", "metadata": {}, "source": [ "First, get the probabilities of each complaint type in your whole dataframe and store them in the variable `nyc_probs`. \n", "\n", "
Hint:\n", "The function `value_counts()` computes how many of each complaint happened, and adding the parameter `normalize = True` will divide each count by the total number of complaints, giving the probability.\n", "
" ] }, { "cell_type": "code", "execution_count": 9, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "HEAT/HOT WATER 0.121918\n", "Noise - Residential 0.093765\n", "Request Large Bulky Item Collection 0.074121\n", "Illegal Parking 0.066566\n", "Blocked Driveway 0.061397\n", "Street Condition 0.042150\n", "UNSANITARY CONDITION 0.029744\n", "Traffic Signal Condition 0.028631\n", "PAINT/PLASTER 0.026722\n", "Street Light Condition 0.022268\n", "PLUMBING 0.022268\n", "Noise 0.019723\n", "Sewer 0.018928\n", "Electronics Waste 0.016463\n", "WATER LEAK 0.016224\n", "Noise - Commercial 0.015190\n", "Snow 0.014872\n", "DOOR/WINDOW 0.014633\n", "Water System 0.014554\n", "Rodent 0.013122\n", "Damaged Tree 0.012884\n", "Noise - Vehicle 0.011452\n", "ELECTRIC 0.010736\n", "Derelict Vehicle 0.009941\n", "FLOORING/STAIRS 0.009623\n", "Dirty Conditions 0.009544\n", "Noise - Street/Sidewalk 0.009464\n", "GENERAL 0.009384\n", "Sanitation Condition 0.009146\n", "Building/Use 0.008430\n", " ... \n", "Overflowing Litter Baskets 0.000159\n", "BEST/Site Safety 0.000159\n", "DOF Parking - DMV Clearance 0.000159\n", "DOF Parking - Request Status 0.000159\n", "Panhandling 0.000159\n", "Elder Abuse 0.000159\n", "Bus Stop Shelter Complaint 0.000159\n", "Recycling Enforcement 0.000159\n", "Highway Sign - Missing 0.000159\n", "Noise - House of Worship 0.000080\n", "Senior Center Complaint 0.000080\n", "Municipal Parking Facility 0.000080\n", "Found Property 0.000080\n", "Bus Stop Shelter Placement 0.000080\n", "Missed Collection (All Materials) 0.000080\n", "Foam Ban Enforcement 0.000080\n", "DOF Property - RPIE Issue 0.000080\n", "Ferry Complaint 0.000080\n", "Home Care Provider Complaint 0.000080\n", "Non-Residential Heat 0.000080\n", "Advocate - Other 0.000080\n", "Tattooing 0.000080\n", "Day Care 0.000080\n", "Noise - Helicopter 0.000080\n", "School Maintenance 0.000080\n", "Illegal Animal Kept as Pet 0.000080\n", "Scaffold Safety 0.000080\n", "Vacant Lot 0.000080\n", "Bike/Roller/Skate Chronic 0.000080\n", "Advocate-Prop Refunds/Credits 0.000080\n", "Name: Complaint Type, Length: 144, dtype: float64" ] }, "execution_count": 9, "metadata": {}, "output_type": "execute_result" } ], "source": [ "nyc_probs = calls[\"Complaint Type\"].value_counts(normalize = True)\n", "nyc_probs" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "Next, create a new dataframe of only the calls from zip code 10468 (or a zip code of your choice.) \n", "\n", "
Hint:\n", "Create a filter and then apply it. You will have to look in the dataframe to see what the column containing the zip code is called.\n", "
" ] }, { "cell_type": "code", "execution_count": 14, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
Unique KeyCreated DateClosed DateAgencyAgency NameComplaint TypeDescriptorLocation TypeIncident ZipIncident AddressStreet NameCross Street 1Cross Street 2Intersection Street 1Intersection Street 2Address TypeCityLandmarkFacility TypeStatusDue DateResolution DescriptionResolution Action Updated DateCommunity BoardBBLBoroughX Coordinate (State Plane)Y Coordinate (State Plane)Open Data Channel TypePark Facility NamePark BoroughVehicle TypeTaxi Company BoroughTaxi Pick Up LocationBridge Highway NameBridge Highway DirectionRoad RampBridge Highway SegmentLatitudeLongitudeLocation
714185821003/03/2019 12:03:53 AM03/03/2019 02:07:40 AMNYPDNew York City Police DepartmentNoise - ResidentialLoud Music/PartyResidential Building/House10468.02784 MORRIS AVENUEMORRIS AVENUEEAST 196 STREETBENDNaNNaNADDRESSBRONXNaNPrecinctClosed03/03/2019 08:03:53 AMThe Police Department responded to the complai...03/03/2019 02:07:40 AM07 BRONX2.033180e+09BRONX1013532.0256126.0ONLINEUnspecifiedBRONXNaNNaNNaNNaNNaNNaNNaN40.869633-73.894126(40.86963264477741, -73.89412645327025)
1214185715803/03/2019 12:13:36 AM03/03/2019 02:06:39 AMNYPDNew York City Police DepartmentNoise - ResidentialLoud Music/PartyResidential Building/House10468.02710 MORRIS AVENUEMORRIS AVENUEEAST KINGSBRIDGE ROADEAST 196 STREETNaNNaNADDRESSBRONXNaNPrecinctClosed03/03/2019 08:13:36 AMThe Police Department responded to the complai...03/03/2019 02:06:39 AM07 BRONX2.033160e+09BRONX1013124.0255501.0PHONEUnspecifiedBRONXNaNNaNNaNNaNNaNNaNNaN40.867919-73.895604(40.8679185556592, -73.89560433136421)
1374185534103/03/2019 12:18:54 AM03/03/2019 01:42:08 AMNYPDNew York City Police DepartmentNoise - ResidentialBanging/PoundingResidential Building/House10468.02285 SEDGWICK AVENUESEDGWICK AVENUEWEST 183 STREETBENDNaNNaNADDRESSBRONXNaNPrecinctClosed03/03/2019 08:18:54 AMYour request can not be processed at this time...03/03/2019 01:42:08 AM07 BRONX2.032340e+09BRONX1009217.0253170.0ONLINEUnspecifiedBRONXNaNNaNNaNNaNNaNNaNNaN40.861533-73.909739(40.861532585666495, -73.90973899619243)
1494186301803/03/2019 12:21:51 AM03/08/2019 02:11:23 AMHPDDepartment of Housing Preservation and Develop...HEAT/HOT WATERENTIRE BUILDINGRESIDENTIAL BUILDING10468.02615 GRAND CONCOURSEGRAND CONCOURSENaNNaNNaNNaNADDRESSBRONXNaNNaNClosedNaNThe complaint you filed is a duplicate of a co...03/08/2019 02:11:23 AM07 BRONX2.031680e+09BRONX1013236.0254437.0MOBILEUnspecifiedBRONXNaNNaNNaNNaNNaNNaNNaN40.864998-73.895204(40.864997833971316, -73.89520399133355)
1614185574203/03/2019 12:23:48 AM03/03/2019 02:07:41 AMNYPDNew York City Police DepartmentNoise - ResidentialLoud Music/PartyResidential Building/House10468.02784 MORRIS AVENUEMORRIS AVENUEEAST 196 STREETBENDNaNNaNADDRESSBRONXNaNPrecinctClosed03/03/2019 08:23:48 AMThe Police Department responded to the complai...03/03/2019 02:07:41 AM07 BRONX2.033180e+09BRONX1013532.0256126.0ONLINEUnspecifiedBRONXNaNNaNNaNNaNNaNNaNNaN40.869633-73.894126(40.86963264477741, -73.89412645327025)
\n", "
" ], "text/plain": [ " Unique Key Created Date Closed Date Agency \\\n", "71 41858210 03/03/2019 12:03:53 AM 03/03/2019 02:07:40 AM NYPD \n", "121 41857158 03/03/2019 12:13:36 AM 03/03/2019 02:06:39 AM NYPD \n", "137 41855341 03/03/2019 12:18:54 AM 03/03/2019 01:42:08 AM NYPD \n", "149 41863018 03/03/2019 12:21:51 AM 03/08/2019 02:11:23 AM HPD \n", "161 41855742 03/03/2019 12:23:48 AM 03/03/2019 02:07:41 AM NYPD \n", "\n", " Agency Name Complaint Type \\\n", "71 New York City Police Department Noise - Residential \n", "121 New York City Police Department Noise - Residential \n", "137 New York City Police Department Noise - Residential \n", "149 Department of Housing Preservation and Develop... HEAT/HOT WATER \n", "161 New York City Police Department Noise - Residential \n", "\n", " Descriptor Location Type Incident Zip \\\n", "71 Loud Music/Party Residential Building/House 10468.0 \n", "121 Loud Music/Party Residential Building/House 10468.0 \n", "137 Banging/Pounding Residential Building/House 10468.0 \n", "149 ENTIRE BUILDING RESIDENTIAL BUILDING 10468.0 \n", "161 Loud Music/Party Residential Building/House 10468.0 \n", "\n", " Incident Address Street Name Cross Street 1 \\\n", "71 2784 MORRIS AVENUE MORRIS AVENUE EAST 196 STREET \n", "121 2710 MORRIS AVENUE MORRIS AVENUE EAST KINGSBRIDGE ROAD \n", "137 2285 SEDGWICK AVENUE SEDGWICK AVENUE WEST 183 STREET \n", "149 2615 GRAND CONCOURSE GRAND CONCOURSE NaN \n", "161 2784 MORRIS AVENUE MORRIS AVENUE EAST 196 STREET \n", "\n", " Cross Street 2 Intersection Street 1 Intersection Street 2 Address Type \\\n", "71 BEND NaN NaN ADDRESS \n", "121 EAST 196 STREET NaN NaN ADDRESS \n", "137 BEND NaN NaN ADDRESS \n", "149 NaN NaN NaN ADDRESS \n", "161 BEND NaN NaN ADDRESS \n", "\n", " City Landmark Facility Type Status Due Date \\\n", "71 BRONX NaN Precinct Closed 03/03/2019 08:03:53 AM \n", "121 BRONX NaN Precinct Closed 03/03/2019 08:13:36 AM \n", "137 BRONX NaN Precinct Closed 03/03/2019 08:18:54 AM \n", "149 BRONX NaN NaN Closed NaN \n", "161 BRONX NaN Precinct Closed 03/03/2019 08:23:48 AM \n", "\n", " Resolution Description \\\n", "71 The Police Department responded to the complai... \n", "121 The Police Department responded to the complai... \n", "137 Your request can not be processed at this time... \n", "149 The complaint you filed is a duplicate of a co... \n", "161 The Police Department responded to the complai... \n", "\n", " Resolution Action Updated Date Community Board BBL Borough \\\n", "71 03/03/2019 02:07:40 AM 07 BRONX 2.033180e+09 BRONX \n", "121 03/03/2019 02:06:39 AM 07 BRONX 2.033160e+09 BRONX \n", "137 03/03/2019 01:42:08 AM 07 BRONX 2.032340e+09 BRONX \n", "149 03/08/2019 02:11:23 AM 07 BRONX 2.031680e+09 BRONX \n", "161 03/03/2019 02:07:41 AM 07 BRONX 2.033180e+09 BRONX \n", "\n", " X Coordinate (State Plane) Y Coordinate (State Plane) \\\n", "71 1013532.0 256126.0 \n", "121 1013124.0 255501.0 \n", "137 1009217.0 253170.0 \n", "149 1013236.0 254437.0 \n", "161 1013532.0 256126.0 \n", "\n", " Open Data Channel Type Park Facility Name Park Borough Vehicle Type \\\n", "71 ONLINE Unspecified BRONX NaN \n", "121 PHONE Unspecified BRONX NaN \n", "137 ONLINE Unspecified BRONX NaN \n", "149 MOBILE Unspecified BRONX NaN \n", "161 ONLINE Unspecified BRONX NaN \n", "\n", " Taxi Company Borough Taxi Pick Up Location Bridge Highway Name \\\n", "71 NaN NaN NaN \n", "121 NaN NaN NaN \n", "137 NaN NaN NaN \n", "149 NaN NaN NaN \n", "161 NaN NaN NaN \n", "\n", " Bridge Highway Direction Road Ramp Bridge Highway Segment Latitude \\\n", "71 NaN NaN NaN 40.869633 \n", "121 NaN NaN NaN 40.867919 \n", "137 NaN NaN NaN 40.861533 \n", "149 NaN NaN NaN 40.864998 \n", "161 NaN NaN NaN 40.869633 \n", "\n", " Longitude Location \n", "71 -73.894126 (40.86963264477741, -73.89412645327025) \n", "121 -73.895604 (40.8679185556592, -73.89560433136421) \n", "137 -73.909739 (40.861532585666495, -73.90973899619243) \n", "149 -73.895204 (40.864997833971316, -73.89520399133355) \n", "161 -73.894126 (40.86963264477741, -73.89412645327025) " ] }, "execution_count": 14, "metadata": {}, "output_type": "execute_result" } ], "source": [ "zip_filter = calls[\"Incident Zip\"] == 10468\n", "calls_lehman = calls[zip_filter]\n", "calls_lehman.head()" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "
Answer:\n", "lehman_filter = calls[\"Incident Zip\"] == 10468\n", "lehman_calls = calls[lehman_filter]\n", "
\n", "\n", "Compute the probabilities of the different complaints in the 10468 zip code." ] }, { "cell_type": "code", "execution_count": 16, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "Noise - Residential 0.270833\n", "HEAT/HOT WATER 0.208333\n", "PAINT/PLASTER 0.145833\n", "Street Condition 0.055556\n", "UNSANITARY CONDITION 0.048611\n", "WATER LEAK 0.041667\n", "Illegal Parking 0.041667\n", "Noise - Commercial 0.034722\n", "PLUMBING 0.020833\n", "ELECTRIC 0.020833\n", "Blocked Driveway 0.020833\n", "DOOR/WINDOW 0.013889\n", "Noise - Street/Sidewalk 0.006944\n", "Snow 0.006944\n", "Noise - Vehicle 0.006944\n", "Rodent 0.006944\n", "Animal Abuse 0.006944\n", "Sewer 0.006944\n", "GENERAL 0.006944\n", "FLOORING/STAIRS 0.006944\n", "Smoking 0.006944\n", "Broken Parking Meter 0.006944\n", "OUTSIDE BUILDING 0.006944\n", "Name: Complaint Type, dtype: float64" ] }, "execution_count": 16, "metadata": {}, "output_type": "execute_result" } ], "source": [ "lehman_probs = calls_lehman[\"Complaint Type\"].value_counts(normalize = True)\n", "lehman_probs" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "Just looking at the first few probabilities in the two distributions, do you notice any differences?\n", "\n", "We will now perform the hypothesis test to formally check if there is a difference between the distributions. We will create a new dataframe containing the two distributions, and then can continue as in the jury panel example in Lab 14. To make a new dataframe called `df` from the probabilities of the NYC complaints, type `df = pd.DataFrame(nyc_probs)` below." ] }, { "cell_type": "code", "execution_count": 17, "metadata": {}, "outputs": [], "source": [ "df = pd.DataFrame(nyc_probs)" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "Check that the dataframe was created correctly." ] }, { "cell_type": "code", "execution_count": 18, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
Complaint Type
HEAT/HOT WATER0.121918
Noise - Residential0.093765
Request Large Bulky Item Collection0.074121
Illegal Parking0.066566
Blocked Driveway0.061397
Street Condition0.042150
UNSANITARY CONDITION0.029744
Traffic Signal Condition0.028631
PAINT/PLASTER0.026722
Street Light Condition0.022268
PLUMBING0.022268
Noise0.019723
Sewer0.018928
Electronics Waste0.016463
WATER LEAK0.016224
Noise - Commercial0.015190
Snow0.014872
DOOR/WINDOW0.014633
Water System0.014554
Rodent0.013122
Damaged Tree0.012884
Noise - Vehicle0.011452
ELECTRIC0.010736
Derelict Vehicle0.009941
FLOORING/STAIRS0.009623
Dirty Conditions0.009544
Noise - Street/Sidewalk0.009464
GENERAL0.009384
Sanitation Condition0.009146
Building/Use0.008430
......
Overflowing Litter Baskets0.000159
BEST/Site Safety0.000159
DOF Parking - DMV Clearance0.000159
DOF Parking - Request Status0.000159
Panhandling0.000159
Elder Abuse0.000159
Bus Stop Shelter Complaint0.000159
Recycling Enforcement0.000159
Highway Sign - Missing0.000159
Noise - House of Worship0.000080
Senior Center Complaint0.000080
Municipal Parking Facility0.000080
Found Property0.000080
Bus Stop Shelter Placement0.000080
Missed Collection (All Materials)0.000080
Foam Ban Enforcement0.000080
DOF Property - RPIE Issue0.000080
Ferry Complaint0.000080
Home Care Provider Complaint0.000080
Non-Residential Heat0.000080
Advocate - Other0.000080
Tattooing0.000080
Day Care0.000080
Noise - Helicopter0.000080
School Maintenance0.000080
Illegal Animal Kept as Pet0.000080
Scaffold Safety0.000080
Vacant Lot0.000080
Bike/Roller/Skate Chronic0.000080
Advocate-Prop Refunds/Credits0.000080
\n", "

144 rows × 1 columns

\n", "
" ], "text/plain": [ " Complaint Type\n", "HEAT/HOT WATER 0.121918\n", "Noise - Residential 0.093765\n", "Request Large Bulky Item Collection 0.074121\n", "Illegal Parking 0.066566\n", "Blocked Driveway 0.061397\n", "Street Condition 0.042150\n", "UNSANITARY CONDITION 0.029744\n", "Traffic Signal Condition 0.028631\n", "PAINT/PLASTER 0.026722\n", "Street Light Condition 0.022268\n", "PLUMBING 0.022268\n", "Noise 0.019723\n", "Sewer 0.018928\n", "Electronics Waste 0.016463\n", "WATER LEAK 0.016224\n", "Noise - Commercial 0.015190\n", "Snow 0.014872\n", "DOOR/WINDOW 0.014633\n", "Water System 0.014554\n", "Rodent 0.013122\n", "Damaged Tree 0.012884\n", "Noise - Vehicle 0.011452\n", "ELECTRIC 0.010736\n", "Derelict Vehicle 0.009941\n", "FLOORING/STAIRS 0.009623\n", "Dirty Conditions 0.009544\n", "Noise - Street/Sidewalk 0.009464\n", "GENERAL 0.009384\n", "Sanitation Condition 0.009146\n", "Building/Use 0.008430\n", "... ...\n", "Overflowing Litter Baskets 0.000159\n", "BEST/Site Safety 0.000159\n", "DOF Parking - DMV Clearance 0.000159\n", "DOF Parking - Request Status 0.000159\n", "Panhandling 0.000159\n", "Elder Abuse 0.000159\n", "Bus Stop Shelter Complaint 0.000159\n", "Recycling Enforcement 0.000159\n", "Highway Sign - Missing 0.000159\n", "Noise - House of Worship 0.000080\n", "Senior Center Complaint 0.000080\n", "Municipal Parking Facility 0.000080\n", "Found Property 0.000080\n", "Bus Stop Shelter Placement 0.000080\n", "Missed Collection (All Materials) 0.000080\n", "Foam Ban Enforcement 0.000080\n", "DOF Property - RPIE Issue 0.000080\n", "Ferry Complaint 0.000080\n", "Home Care Provider Complaint 0.000080\n", "Non-Residential Heat 0.000080\n", "Advocate - Other 0.000080\n", "Tattooing 0.000080\n", "Day Care 0.000080\n", "Noise - Helicopter 0.000080\n", "School Maintenance 0.000080\n", "Illegal Animal Kept as Pet 0.000080\n", "Scaffold Safety 0.000080\n", "Vacant Lot 0.000080\n", "Bike/Roller/Skate Chronic 0.000080\n", "Advocate-Prop Refunds/Credits 0.000080\n", "\n", "[144 rows x 1 columns]" ] }, "execution_count": 18, "metadata": {}, "output_type": "execute_result" } ], "source": [ "df" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "Next let's add a column to our dataframe `df` containing the 10468 complaint probabilities. Again display the new dataframe to check your code worked." ] }, { "cell_type": "code", "execution_count": 20, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
Complaint Typelehman_zip
HEAT/HOT WATER0.1219180.208333
Noise - Residential0.0937650.270833
Request Large Bulky Item Collection0.074121NaN
Illegal Parking0.0665660.041667
Blocked Driveway0.0613970.020833
Street Condition0.0421500.055556
UNSANITARY CONDITION0.0297440.048611
Traffic Signal Condition0.028631NaN
PAINT/PLASTER0.0267220.145833
Street Light Condition0.022268NaN
PLUMBING0.0222680.020833
Noise0.019723NaN
Sewer0.0189280.006944
Electronics Waste0.016463NaN
WATER LEAK0.0162240.041667
Noise - Commercial0.0151900.034722
Snow0.0148720.006944
DOOR/WINDOW0.0146330.013889
Water System0.014554NaN
Rodent0.0131220.006944
Damaged Tree0.012884NaN
Noise - Vehicle0.0114520.006944
ELECTRIC0.0107360.020833
Derelict Vehicle0.009941NaN
FLOORING/STAIRS0.0096230.006944
Dirty Conditions0.009544NaN
Noise - Street/Sidewalk0.0094640.006944
GENERAL0.0093840.006944
Sanitation Condition0.009146NaN
Building/Use0.008430NaN
.........
Overflowing Litter Baskets0.000159NaN
BEST/Site Safety0.000159NaN
DOF Parking - DMV Clearance0.000159NaN
DOF Parking - Request Status0.000159NaN
Panhandling0.000159NaN
Elder Abuse0.000159NaN
Bus Stop Shelter Complaint0.000159NaN
Recycling Enforcement0.000159NaN
Highway Sign - Missing0.000159NaN
Noise - House of Worship0.000080NaN
Senior Center Complaint0.000080NaN
Municipal Parking Facility0.000080NaN
Found Property0.000080NaN
Bus Stop Shelter Placement0.000080NaN
Missed Collection (All Materials)0.000080NaN
Foam Ban Enforcement0.000080NaN
DOF Property - RPIE Issue0.000080NaN
Ferry Complaint0.000080NaN
Home Care Provider Complaint0.000080NaN
Non-Residential Heat0.000080NaN
Advocate - Other0.000080NaN
Tattooing0.000080NaN
Day Care0.000080NaN
Noise - Helicopter0.000080NaN
School Maintenance0.000080NaN
Illegal Animal Kept as Pet0.000080NaN
Scaffold Safety0.000080NaN
Vacant Lot0.000080NaN
Bike/Roller/Skate Chronic0.000080NaN
Advocate-Prop Refunds/Credits0.000080NaN
\n", "

144 rows × 2 columns

\n", "
" ], "text/plain": [ " Complaint Type lehman_zip\n", "HEAT/HOT WATER 0.121918 0.208333\n", "Noise - Residential 0.093765 0.270833\n", "Request Large Bulky Item Collection 0.074121 NaN\n", "Illegal Parking 0.066566 0.041667\n", "Blocked Driveway 0.061397 0.020833\n", "Street Condition 0.042150 0.055556\n", "UNSANITARY CONDITION 0.029744 0.048611\n", "Traffic Signal Condition 0.028631 NaN\n", "PAINT/PLASTER 0.026722 0.145833\n", "Street Light Condition 0.022268 NaN\n", "PLUMBING 0.022268 0.020833\n", "Noise 0.019723 NaN\n", "Sewer 0.018928 0.006944\n", "Electronics Waste 0.016463 NaN\n", "WATER LEAK 0.016224 0.041667\n", "Noise - Commercial 0.015190 0.034722\n", "Snow 0.014872 0.006944\n", "DOOR/WINDOW 0.014633 0.013889\n", "Water System 0.014554 NaN\n", "Rodent 0.013122 0.006944\n", "Damaged Tree 0.012884 NaN\n", "Noise - Vehicle 0.011452 0.006944\n", "ELECTRIC 0.010736 0.020833\n", "Derelict Vehicle 0.009941 NaN\n", "FLOORING/STAIRS 0.009623 0.006944\n", "Dirty Conditions 0.009544 NaN\n", "Noise - Street/Sidewalk 0.009464 0.006944\n", "GENERAL 0.009384 0.006944\n", "Sanitation Condition 0.009146 NaN\n", "Building/Use 0.008430 NaN\n", "... ... ...\n", "Overflowing Litter Baskets 0.000159 NaN\n", "BEST/Site Safety 0.000159 NaN\n", "DOF Parking - DMV Clearance 0.000159 NaN\n", "DOF Parking - Request Status 0.000159 NaN\n", "Panhandling 0.000159 NaN\n", "Elder Abuse 0.000159 NaN\n", "Bus Stop Shelter Complaint 0.000159 NaN\n", "Recycling Enforcement 0.000159 NaN\n", "Highway Sign - Missing 0.000159 NaN\n", "Noise - House of Worship 0.000080 NaN\n", "Senior Center Complaint 0.000080 NaN\n", "Municipal Parking Facility 0.000080 NaN\n", "Found Property 0.000080 NaN\n", "Bus Stop Shelter Placement 0.000080 NaN\n", "Missed Collection (All Materials) 0.000080 NaN\n", "Foam Ban Enforcement 0.000080 NaN\n", "DOF Property - RPIE Issue 0.000080 NaN\n", "Ferry Complaint 0.000080 NaN\n", "Home Care Provider Complaint 0.000080 NaN\n", "Non-Residential Heat 0.000080 NaN\n", "Advocate - Other 0.000080 NaN\n", "Tattooing 0.000080 NaN\n", "Day Care 0.000080 NaN\n", "Noise - Helicopter 0.000080 NaN\n", "School Maintenance 0.000080 NaN\n", "Illegal Animal Kept as Pet 0.000080 NaN\n", "Scaffold Safety 0.000080 NaN\n", "Vacant Lot 0.000080 NaN\n", "Bike/Roller/Skate Chronic 0.000080 NaN\n", "Advocate-Prop Refunds/Credits 0.000080 NaN\n", "\n", "[144 rows x 2 columns]" ] }, "execution_count": 20, "metadata": {}, "output_type": "execute_result" } ], "source": [ "df[\"lehman_zip\"] = lehman_probs\n", "df" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "Some complaints showed up in the NYC calls, but not the calls from zip 10468. How can you tell which complaints these are in the dataframe?\n", "\n", "Complaints were in the NYC calls but not the 10468 calls have `NaN` for the probability in the 10468 column. If we wanted to replace `NaN` with a number, what should the number be?\n", "\n", "To replace the NaNs with 0's, type `df = df.fillna(0)` below and run it. Note that you need `df=` to save the changes you made." ] }, { "cell_type": "code", "execution_count": 22, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
Complaint Typelehman_zip
HEAT/HOT WATER0.1219180.208333
Noise - Residential0.0937650.270833
Request Large Bulky Item Collection0.0741210.000000
Illegal Parking0.0665660.041667
Blocked Driveway0.0613970.020833
Street Condition0.0421500.055556
UNSANITARY CONDITION0.0297440.048611
Traffic Signal Condition0.0286310.000000
PAINT/PLASTER0.0267220.145833
Street Light Condition0.0222680.000000
PLUMBING0.0222680.020833
Noise0.0197230.000000
Sewer0.0189280.006944
Electronics Waste0.0164630.000000
WATER LEAK0.0162240.041667
Noise - Commercial0.0151900.034722
Snow0.0148720.006944
DOOR/WINDOW0.0146330.013889
Water System0.0145540.000000
Rodent0.0131220.006944
Damaged Tree0.0128840.000000
Noise - Vehicle0.0114520.006944
ELECTRIC0.0107360.020833
Derelict Vehicle0.0099410.000000
FLOORING/STAIRS0.0096230.006944
Dirty Conditions0.0095440.000000
Noise - Street/Sidewalk0.0094640.006944
GENERAL0.0093840.006944
Sanitation Condition0.0091460.000000
Building/Use0.0084300.000000
.........
Overflowing Litter Baskets0.0001590.000000
BEST/Site Safety0.0001590.000000
DOF Parking - DMV Clearance0.0001590.000000
DOF Parking - Request Status0.0001590.000000
Panhandling0.0001590.000000
Elder Abuse0.0001590.000000
Bus Stop Shelter Complaint0.0001590.000000
Recycling Enforcement0.0001590.000000
Highway Sign - Missing0.0001590.000000
Noise - House of Worship0.0000800.000000
Senior Center Complaint0.0000800.000000
Municipal Parking Facility0.0000800.000000
Found Property0.0000800.000000
Bus Stop Shelter Placement0.0000800.000000
Missed Collection (All Materials)0.0000800.000000
Foam Ban Enforcement0.0000800.000000
DOF Property - RPIE Issue0.0000800.000000
Ferry Complaint0.0000800.000000
Home Care Provider Complaint0.0000800.000000
Non-Residential Heat0.0000800.000000
Advocate - Other0.0000800.000000
Tattooing0.0000800.000000
Day Care0.0000800.000000
Noise - Helicopter0.0000800.000000
School Maintenance0.0000800.000000
Illegal Animal Kept as Pet0.0000800.000000
Scaffold Safety0.0000800.000000
Vacant Lot0.0000800.000000
Bike/Roller/Skate Chronic0.0000800.000000
Advocate-Prop Refunds/Credits0.0000800.000000
\n", "

144 rows × 2 columns

\n", "
" ], "text/plain": [ " Complaint Type lehman_zip\n", "HEAT/HOT WATER 0.121918 0.208333\n", "Noise - Residential 0.093765 0.270833\n", "Request Large Bulky Item Collection 0.074121 0.000000\n", "Illegal Parking 0.066566 0.041667\n", "Blocked Driveway 0.061397 0.020833\n", "Street Condition 0.042150 0.055556\n", "UNSANITARY CONDITION 0.029744 0.048611\n", "Traffic Signal Condition 0.028631 0.000000\n", "PAINT/PLASTER 0.026722 0.145833\n", "Street Light Condition 0.022268 0.000000\n", "PLUMBING 0.022268 0.020833\n", "Noise 0.019723 0.000000\n", "Sewer 0.018928 0.006944\n", "Electronics Waste 0.016463 0.000000\n", "WATER LEAK 0.016224 0.041667\n", "Noise - Commercial 0.015190 0.034722\n", "Snow 0.014872 0.006944\n", "DOOR/WINDOW 0.014633 0.013889\n", "Water System 0.014554 0.000000\n", "Rodent 0.013122 0.006944\n", "Damaged Tree 0.012884 0.000000\n", "Noise - Vehicle 0.011452 0.006944\n", "ELECTRIC 0.010736 0.020833\n", "Derelict Vehicle 0.009941 0.000000\n", "FLOORING/STAIRS 0.009623 0.006944\n", "Dirty Conditions 0.009544 0.000000\n", "Noise - Street/Sidewalk 0.009464 0.006944\n", "GENERAL 0.009384 0.006944\n", "Sanitation Condition 0.009146 0.000000\n", "Building/Use 0.008430 0.000000\n", "... ... ...\n", "Overflowing Litter Baskets 0.000159 0.000000\n", "BEST/Site Safety 0.000159 0.000000\n", "DOF Parking - DMV Clearance 0.000159 0.000000\n", "DOF Parking - Request Status 0.000159 0.000000\n", "Panhandling 0.000159 0.000000\n", "Elder Abuse 0.000159 0.000000\n", "Bus Stop Shelter Complaint 0.000159 0.000000\n", "Recycling Enforcement 0.000159 0.000000\n", "Highway Sign - Missing 0.000159 0.000000\n", "Noise - House of Worship 0.000080 0.000000\n", "Senior Center Complaint 0.000080 0.000000\n", "Municipal Parking Facility 0.000080 0.000000\n", "Found Property 0.000080 0.000000\n", "Bus Stop Shelter Placement 0.000080 0.000000\n", "Missed Collection (All Materials) 0.000080 0.000000\n", "Foam Ban Enforcement 0.000080 0.000000\n", "DOF Property - RPIE Issue 0.000080 0.000000\n", "Ferry Complaint 0.000080 0.000000\n", "Home Care Provider Complaint 0.000080 0.000000\n", "Non-Residential Heat 0.000080 0.000000\n", "Advocate - Other 0.000080 0.000000\n", "Tattooing 0.000080 0.000000\n", "Day Care 0.000080 0.000000\n", "Noise - Helicopter 0.000080 0.000000\n", "School Maintenance 0.000080 0.000000\n", "Illegal Animal Kept as Pet 0.000080 0.000000\n", "Scaffold Safety 0.000080 0.000000\n", "Vacant Lot 0.000080 0.000000\n", "Bike/Roller/Skate Chronic 0.000080 0.000000\n", "Advocate-Prop Refunds/Credits 0.000080 0.000000\n", "\n", "[144 rows x 2 columns]" ] }, "execution_count": 22, "metadata": {}, "output_type": "execute_result" } ], "source": [ "df = df.fillna(0)\n", "df" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "Check that the NaNs have been replaced by 0's by displaying `df`." ] }, { "cell_type": "code", "execution_count": null, "metadata": { "collapsed": true }, "outputs": [], "source": [] }, { "cell_type": "markdown", "metadata": {}, "source": [ "We want to know if the differences between the 10468 complaint distribution and the NYC complain distribution are just due to chance or because the distributions are different. To test this, we need to:\n", "\n", "1. Compute the size of the sample of 10468 complaints (to know how large our samples in step 3 should be). \n", "2. Compute the Total Variation Distance (TVD) between the 10468 and NYC complaint distributions\n", "3. Compute the Total Variation Distances between samples from all complaints and the NYC complaint distribution and make a histogram of them.\n", "4. Compare the TVD from step 2 with the histogram from step 3, and accept or reject the null hypothesis.\n", "\n", "Do step 1: compute the size of the sample of 10468 complaints (to know how large our samples in step 3 should be)" ] }, { "cell_type": "code", "execution_count": 23, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "(144, 41)" ] }, "execution_count": 23, "metadata": {}, "output_type": "execute_result" } ], "source": [ "calls_lehman.shape" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "Do step 2: compute the Total Variation Distance (TVD) between the 10468 and NYC complaint distributions.\n", "\n", "That is, compute the TVD between the `Complaint Type` and `10468 Complaints` columns in your dataframe `df`." ] }, { "cell_type": "code", "execution_count": 24, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "0.4905592227347436" ] }, "execution_count": 24, "metadata": {}, "output_type": "execute_result" } ], "source": [ "np.abs(df[\"Complaint Type\"] - df[\"lehman_zip\"]).sum()/2" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "
Answer:\n", "np.abs(df[\"Complaint Type\"] - df[\"10468 Complaints\"]).sum()/2\n", "
\n", "\n", "We will break step 3 up. First, let's generate one sample from the NYC complaint distributions. Instead of simulating the sample like in the previous hypothesis testing examples, simply take a sample of size 144 from the `calls` dataframe." ] }, { "cell_type": "code", "execution_count": 26, "metadata": {}, "outputs": [], "source": [ "sample = calls.sample(144)" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "Compute the probabilities for the complaints in the sample, and add them to dataframe `df` as a new column. Remember to replace the NaNs with 0's." ] }, { "cell_type": "code", "execution_count": 33, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
Complaint Typelehman_ziprandom
HEAT/HOT WATER0.1219180.2083330.097222
Noise - Residential0.0937650.2708330.125000
Request Large Bulky Item Collection0.0741210.0000000.083333
Illegal Parking0.0665660.0416670.055556
Blocked Driveway0.0613970.0208330.069444
Street Condition0.0421500.0555560.013889
UNSANITARY CONDITION0.0297440.0486110.048611
Traffic Signal Condition0.0286310.0000000.027778
PAINT/PLASTER0.0267220.1458330.013889
Street Light Condition0.0222680.0000000.013889
PLUMBING0.0222680.0208330.006944
Noise0.0197230.0000000.006944
Sewer0.0189280.0069440.041667
Electronics Waste0.0164630.0000000.013889
WATER LEAK0.0162240.0416670.006944
Noise - Commercial0.0151900.0347220.013889
Snow0.0148720.0069440.006944
DOOR/WINDOW0.0146330.0138890.006944
Water System0.0145540.0000000.013889
Rodent0.0131220.0069440.006944
Damaged Tree0.0128840.0000000.020833
Noise - Vehicle0.0114520.0069440.027778
ELECTRIC0.0107360.0208330.013889
Derelict Vehicle0.0099410.0000000.000000
FLOORING/STAIRS0.0096230.0069440.006944
Dirty Conditions0.0095440.0000000.020833
Noise - Street/Sidewalk0.0094640.0069440.013889
GENERAL0.0093840.0069440.000000
Sanitation Condition0.0091460.0000000.020833
Building/Use0.0084300.0000000.000000
............
Overflowing Litter Baskets0.0001590.0000000.000000
BEST/Site Safety0.0001590.0000000.000000
DOF Parking - DMV Clearance0.0001590.0000000.000000
DOF Parking - Request Status0.0001590.0000000.000000
Panhandling0.0001590.0000000.000000
Elder Abuse0.0001590.0000000.000000
Bus Stop Shelter Complaint0.0001590.0000000.000000
Recycling Enforcement0.0001590.0000000.000000
Highway Sign - Missing0.0001590.0000000.000000
Noise - House of Worship0.0000800.0000000.000000
Senior Center Complaint0.0000800.0000000.000000
Municipal Parking Facility0.0000800.0000000.000000
Found Property0.0000800.0000000.000000
Bus Stop Shelter Placement0.0000800.0000000.000000
Missed Collection (All Materials)0.0000800.0000000.000000
Foam Ban Enforcement0.0000800.0000000.000000
DOF Property - RPIE Issue0.0000800.0000000.000000
Ferry Complaint0.0000800.0000000.000000
Home Care Provider Complaint0.0000800.0000000.000000
Non-Residential Heat0.0000800.0000000.000000
Advocate - Other0.0000800.0000000.000000
Tattooing0.0000800.0000000.000000
Day Care0.0000800.0000000.000000
Noise - Helicopter0.0000800.0000000.000000
School Maintenance0.0000800.0000000.000000
Illegal Animal Kept as Pet0.0000800.0000000.000000
Scaffold Safety0.0000800.0000000.000000
Vacant Lot0.0000800.0000000.000000
Bike/Roller/Skate Chronic0.0000800.0000000.000000
Advocate-Prop Refunds/Credits0.0000800.0000000.000000
\n", "

144 rows × 3 columns

\n", "
" ], "text/plain": [ " Complaint Type lehman_zip random\n", "HEAT/HOT WATER 0.121918 0.208333 0.097222\n", "Noise - Residential 0.093765 0.270833 0.125000\n", "Request Large Bulky Item Collection 0.074121 0.000000 0.083333\n", "Illegal Parking 0.066566 0.041667 0.055556\n", "Blocked Driveway 0.061397 0.020833 0.069444\n", "Street Condition 0.042150 0.055556 0.013889\n", "UNSANITARY CONDITION 0.029744 0.048611 0.048611\n", "Traffic Signal Condition 0.028631 0.000000 0.027778\n", "PAINT/PLASTER 0.026722 0.145833 0.013889\n", "Street Light Condition 0.022268 0.000000 0.013889\n", "PLUMBING 0.022268 0.020833 0.006944\n", "Noise 0.019723 0.000000 0.006944\n", "Sewer 0.018928 0.006944 0.041667\n", "Electronics Waste 0.016463 0.000000 0.013889\n", "WATER LEAK 0.016224 0.041667 0.006944\n", "Noise - Commercial 0.015190 0.034722 0.013889\n", "Snow 0.014872 0.006944 0.006944\n", "DOOR/WINDOW 0.014633 0.013889 0.006944\n", "Water System 0.014554 0.000000 0.013889\n", "Rodent 0.013122 0.006944 0.006944\n", "Damaged Tree 0.012884 0.000000 0.020833\n", "Noise - Vehicle 0.011452 0.006944 0.027778\n", "ELECTRIC 0.010736 0.020833 0.013889\n", "Derelict Vehicle 0.009941 0.000000 0.000000\n", "FLOORING/STAIRS 0.009623 0.006944 0.006944\n", "Dirty Conditions 0.009544 0.000000 0.020833\n", "Noise - Street/Sidewalk 0.009464 0.006944 0.013889\n", "GENERAL 0.009384 0.006944 0.000000\n", "Sanitation Condition 0.009146 0.000000 0.020833\n", "Building/Use 0.008430 0.000000 0.000000\n", "... ... ... ...\n", "Overflowing Litter Baskets 0.000159 0.000000 0.000000\n", "BEST/Site Safety 0.000159 0.000000 0.000000\n", "DOF Parking - DMV Clearance 0.000159 0.000000 0.000000\n", "DOF Parking - Request Status 0.000159 0.000000 0.000000\n", "Panhandling 0.000159 0.000000 0.000000\n", "Elder Abuse 0.000159 0.000000 0.000000\n", "Bus Stop Shelter Complaint 0.000159 0.000000 0.000000\n", "Recycling Enforcement 0.000159 0.000000 0.000000\n", "Highway Sign - Missing 0.000159 0.000000 0.000000\n", "Noise - House of Worship 0.000080 0.000000 0.000000\n", "Senior Center Complaint 0.000080 0.000000 0.000000\n", "Municipal Parking Facility 0.000080 0.000000 0.000000\n", "Found Property 0.000080 0.000000 0.000000\n", "Bus Stop Shelter Placement 0.000080 0.000000 0.000000\n", "Missed Collection (All Materials) 0.000080 0.000000 0.000000\n", "Foam Ban Enforcement 0.000080 0.000000 0.000000\n", "DOF Property - RPIE Issue 0.000080 0.000000 0.000000\n", "Ferry Complaint 0.000080 0.000000 0.000000\n", "Home Care Provider Complaint 0.000080 0.000000 0.000000\n", "Non-Residential Heat 0.000080 0.000000 0.000000\n", "Advocate - Other 0.000080 0.000000 0.000000\n", "Tattooing 0.000080 0.000000 0.000000\n", "Day Care 0.000080 0.000000 0.000000\n", "Noise - Helicopter 0.000080 0.000000 0.000000\n", "School Maintenance 0.000080 0.000000 0.000000\n", "Illegal Animal Kept as Pet 0.000080 0.000000 0.000000\n", "Scaffold Safety 0.000080 0.000000 0.000000\n", "Vacant Lot 0.000080 0.000000 0.000000\n", "Bike/Roller/Skate Chronic 0.000080 0.000000 0.000000\n", "Advocate-Prop Refunds/Credits 0.000080 0.000000 0.000000\n", "\n", "[144 rows x 3 columns]" ] }, "execution_count": 33, "metadata": {}, "output_type": "execute_result" } ], "source": [ "df[\"random\"] = sample[\"Complaint Type\"].value_counts(normalize = True)\n", "df = df.fillna(0)\n", "df" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "
Answer:\n", "sample_counts = sample[\"Complaint Type\"].value_counts(normalize = True)\n", "df[\"Sample complaints\"] = sample_counts\n", "df = df.fillna(0)\n", "df\n", "
\n", "\n", "Compute the TVD between the sample complaints and all NYC complaints." ] }, { "cell_type": "code", "execution_count": 34, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "0.28177080571903224" ] }, "execution_count": 34, "metadata": {}, "output_type": "execute_result" } ], "source": [ "np.abs(df[\"random\"] - df[\"Complaint Type\"]).sum()/2" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "
Answer:\n", "np.abs(df[\"Sample complaints\"] - df[\"Complaint Type\"]).sum()/2\n", "
\n", "\n", "Now we want to repeat these steps (sample from `calls` and compute the TVD between the sample and all NYC complaints) many times." ] }, { "cell_type": "code", "execution_count": 37, "metadata": {}, "outputs": [], "source": [ "tvds = []\n", "for i in range(1000):\n", " sample = calls.sample(144)\n", " sample_counts = sample[\"Complaint Type\"].value_counts(normalize = True)\n", " df[\"random\"] = sample_counts\n", " df = df.fillna(0)\n", " sample_tvd = np.abs(df[\"random\"] - df[\"Complaint Type\"]).sum()/2\n", " tvds.append(sample_tvd)\n", " " ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "
Answer:\n", "tvds = []\n", "for i in range(10000):\n", " sample = calls.sample(144)\n", " sample_counts = sample[\"Complaint Type\"].value_counts(normalize = True)\n", " df[\"Sample complaints\"] = sample_counts\n", " df = df.fillna(0)\n", " sample_tvd = np.abs(df[\"Sample complaints\"] - df[\"Complaint Type\"]).sum()/2\n", " tvds.append(sample_tvd)\n", "
\n", "\n", "Display the histogram of the TVDs:" ] }, { "cell_type": "code", "execution_count": 39, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "" ] }, "execution_count": 39, "metadata": {}, "output_type": "execute_result" }, { "data": { "image/png": "iVBORw0KGgoAAAANSUhEUgAAAXoAAAD8CAYAAAB5Pm/hAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADl0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uIDIuMi4zLCBodHRwOi8vbWF0cGxvdGxpYi5vcmcvIxREBQAAEmRJREFUeJzt3X2QXXV9x/H31/BQyioJg+7EgK5to9NgWjQrYh3bXR/K02iwdRDGh0RpYyu0dowzBumMtA4zqRYcHazTtFCxVldqsWYgiDGT1dIxaoJpQpJBAsQhaQyDInWR0ka//eOe0Jtls3f3Puw9/Hi/Zu7k3N95uJ/d7P3s2XPOvTcyE0lSuZ7V7wCSpN6y6CWpcBa9JBXOopekwln0klQ4i16SCmfRS1LhLHpJKpxFL0mFO67fAQBOO+20HBoaOmrsscce4+STT+5PoBbM1h6ztafO2aDe+UrPtm3btocz87ktF8zMvt+WLVuWk23evPkpY3VhtvaYrT11zpZZ73ylZwO25gw61kM3klQ4i16SCmfRS1LhWhZ9RJwREZsjYndE7IqI91XjV0fEgYjYXt0uaFrnyojYGxH3RMS5vfwCJEnTm8lVN4eB1Zl5V0Q8G9gWERureR/PzL9uXjgilgCXAGcCzwe+HhEvzsyfdzO4JGlmWu7RZ+bBzLyrmv4psAdYNM0qy4GxzHwiMx8A9gJndyOsJGn2ZnWMPiKGgJcB366GroiIHRFxY0QsqMYWAQ82rbaf6X8xSJJ6KHKGHyUYEQPAN4BrMvOWiBgEHgYS+AiwMDPfHRHXA1sy83PVejcAt2fmlyZtbxWwCmBwcHDZ2NjYUY83MTHBwMBAR19cr5itPWZrT52zQb3zlZ5tdHR0W2YOt1xwJhfbA8cDdwDvP8b8IeDuavpK4MqmeXcAr5pu+75gqnvM1h6zta/O+UrPxgxfMNXyZGxEBHADsCczr2saX5iZB6u7bwburqbXA5+PiOtonIxdDHyn5W8caRpDa27r6fZXLz3MymM8xr61F/b0saVem8lVN68G3gHsjIjt1diHgEsj4iwah272Ae8ByMxdEXEzsJvGFTuXp1fcSFLftCz6zLwTiClmbZhmnWuAazrIJUnqEl8ZK0mFs+glqXAWvSQVzqKXpMJZ9JJUOItekgpn0UtS4Sx6SSqcRS9JhbPoJalwFr0kFc6il6TCWfSSVDiLXpIKZ9FLUuEsekkqnEUvSYWz6CWpcDP5zFjpSZ18SPd0H8AtqXfco5ekwln0klQ4i16SCmfRS1LhLHpJKpxFL0mFs+glqXAWvSQVzqKXpMJZ9JJUOItekgpn0UtS4Sx6SSqcRS9JhWtZ9BFxRkRsjojdEbErIt5XjZ8aERsj4t7q3wXVeETEJyNib0TsiIiX9/qLkCQd20z26A8DqzNzCXAOcHlELAHWAJsyczGwqboPcD6wuLqtAj7d9dSSpBlrWfSZeTAz76qmfwrsARYBy4GbqsVuAi6qppcDn82GLcD8iFjY9eSSpBmZ1TH6iBgCXgZ8GxjMzIPVrB8Cg9X0IuDBptX2V2OSpD6IzJzZghEDwDeAazLzloj4SWbOb5r/SGYuiIhbgbWZeWc1vgn4YGZunbS9VTQO7TA4OLhsbGzsqMebmJhgYGCggy+td57J2XYeeLTtdQdPgkOPdzFMF02XbemiU+Y2zCR1/nmDeucrPdvo6Oi2zBxutdyMPjM2Io4H/gX4p8y8pRo+FBELM/NgdWjmoWr8AHBG0+qnV2NHycx1wDqA4eHhHBkZOWr++Pg4k8fq4pmcrZPPfF299DDX7qznxxRPl23f20bmNswkdf55g3rnM1vDTK66CeAGYE9mXtc0az2woppeAXylafyd1dU35wCPNh3ikSTNsZnsXr0aeAewMyK2V2MfAtYCN0fEZcAPgIureRuAC4C9wM+Ad3U1sSRpVloWfXWsPY4x+3VTLJ/A5R3mkiR1ia+MlaTCWfSSVDiLXpIKZ9FLUuEsekkqnEUvSYWz6CWpcBa9JBXOopekwln0klQ4i16SCmfRS1LhLHpJKpxFL0mFs+glqXAWvSQVzqKXpMJZ9JJUOItekgpn0UtS4Sx6SSqcRS9JhbPoJalwFr0kFe64fgeQ6m5ozW19edx9ay/sy+OqPO7RS1LhLHpJKpxFL0mFs+glqXAWvSQVzqKXpMJZ9JJUOItekgrXsugj4saIeCgi7m4auzoiDkTE9up2QdO8KyNib0TcExHn9iq4JGlmZrJH/xngvCnGP56ZZ1W3DQARsQS4BDizWudvImJet8JKkmavZdFn5jeBH89we8uBscx8IjMfAPYCZ3eQT5LUoU6O0V8RETuqQzsLqrFFwINNy+yvxiRJfRKZ2XqhiCHg1sx8aXV/EHgYSOAjwMLMfHdEXA9syczPVcvdANyemV+aYpurgFUAg4ODy8bGxo6aPzExwcDAQPtfWQ89k7PtPPBo2+sOngSHHu9imC6qY7ali04B6v3zBvXOV3q20dHRbZk53Gq5tt69MjMPHZmOiL8Dbq3uHgDOaFr09Gpsqm2sA9YBDA8P58jIyFHzx8fHmTxWF8/kbCs7eCfH1UsPc+3Oer5hah2z7XvbCFDvnzeodz6zNbR16CYiFjbdfTNw5Iqc9cAlEXFiRLwIWAx8p7OIkqROtNyFiYgvACPAaRGxH/gwMBIRZ9E4dLMPeA9AZu6KiJuB3cBh4PLM/HlvokuSZqJl0WfmpVMM3zDN8tcA13QSSpLUPfU6KKkZme4Tj1YvPdzRcXRJ5fEtECSpcBa9JBXOopekwln0klQ4i16SCmfRS1LhLHpJKpxFL0mFs+glqXAWvSQVzqKXpMJZ9JJUOItekgpn0UtS4Sx6SSqcRS9JhbPoJalwFr0kFc6il6TCWfSSVDiLXpIKZ9FLUuEsekkqnEUvSYWz6CWpcBa9JBXOopekwln0klQ4i16SCmfRS1LhLHpJKpxFL0mFa1n0EXFjRDwUEXc3jZ0aERsj4t7q3wXVeETEJyNib0TsiIiX9zK8JKm1mezRfwY4b9LYGmBTZi4GNlX3Ac4HFle3VcCnuxNTktSulkWfmd8EfjxpeDlwUzV9E3BR0/hns2ELMD8iFnYrrCRp9iIzWy8UMQTcmpkvre7/JDPnV9MBPJKZ8yPiVmBtZt5ZzdsEfDAzt06xzVU09voZHBxcNjY2dtT8iYkJBgYGOvjSeqff2XYeePSY8wZPgkOPz2GYWTDb7CxddArQ/5+3Vuqcr/Rso6Oj2zJzuNVyx3X0KEBmZkS0/m3x1PXWAesAhoeHc2Rk5Kj54+PjTB6ri35nW7nmtmPOW730MNfu7Pi/tSfMNjv73jYC9P/nrZU65zNbQ7tX3Rw6ckim+vehavwAcEbTcqdXY5KkPmm36NcDK6rpFcBXmsbfWV19cw7waGYe7DCjJKkDLf9WjYgvACPAaRGxH/gwsBa4OSIuA34AXFwtvgG4ANgL/Ax4Vw8yS5JmoWXRZ+alx5j1uimWTeDyTkNJkrrHV8ZKUuEsekkqnEUvSYWz6CWpcPV6hYikJw1VL4xbvfTwtC+S67Z9ay+cs8fS3HCPXpIKZ9FLUuEsekkqnEUvSYWz6CWpcBa9JBXOopekwln0klQ4i16SCmfRS1LhLHpJKpxFL0mFs+glqXAWvSQVzqKXpMJZ9JJUOItekgpn0UtS4Sx6SSqcnxnbgaE5/BxPSWqXe/SSVDiLXpIKZ9FLUuEsekkqnEUvSYWz6CWpcBa9JBWuo+voI2If8FPg58DhzByOiFOBLwJDwD7g4sx8pLOYkqR2dWOPfjQzz8rM4er+GmBTZi4GNlX3JUl90otDN8uBm6rpm4CLevAYkqQZ6rToE/haRGyLiFXV2GBmHqymfwgMdvgYkqQORGa2v3LEosw8EBHPAzYCfwKsz8z5Tcs8kpkLplh3FbAKYHBwcNnY2NhR8ycmJhgYGGg7Wy8dybbzwKP9jvIUgyfBocf7nWJqZmvPXGdbuuiUWS3/dHiu1lE3so2Ojm5rOmx+TB0V/VEbirgamAD+EBjJzIMRsRAYz8yXTLfu8PBwbt269aix8fFxRkZGupKt245kq+Obmq1eephrd9bzverM1p65zrZv7YWzWv7p8Fyto25ki4gZFX3bh24i4uSIePaRaeB3gbuB9cCKarEVwFfafQxJUuc62U0YBL4cEUe28/nM/GpEfBe4OSIuA34AXNx5TElSu9ou+sy8H/jNKcZ/BLyuk1CSpO7xlbGSVDiLXpIKZ9FLUuHqeT2ZpL6Z7WXDq5ceZmWXLjWe7aWdmhn36CWpcBa9JBXOopekwln0klQ4i16SCmfRS1LhLHpJKpxFL0mFs+glqXAWvSQVzqKXpMJZ9JJUOItekgpn0UtS4Sx6SSqcRS9JhXvaf/DIbD8koRu6+UELktRr7tFLUuEsekkqnEUvSYWz6CWpcBa9JBXOopekwln0klQ4i16SCmfRS1LhLHpJKpxFL0mFs+glqXA9e1OziDgP+AQwD/j7zFzbq8eSVIZuv0nhTN+AcN/aC7v6uHXTkz36iJgHfAo4H1gCXBoRS3rxWJKk6fVqj/5sYG9m3g8QEWPAcmB3jx5PktrWz7c7n4u/Jnp1jH4R8GDT/f3VmCRpjkVmdn+jEW8BzsvMP6juvwN4ZWZe0bTMKmBVdfclwD2TNnMa8HDXw3WH2dpjtvbUORvUO1/p2V6Ymc9ttVCvDt0cAM5oun96NfakzFwHrDvWBiJia2YO9yZeZ8zWHrO1p87ZoN75zNbQq0M33wUWR8SLIuIE4BJgfY8eS5I0jZ7s0Wfm4Yi4AriDxuWVN2bmrl48liRpej27jj4zNwAbOtjEMQ/r1IDZ2mO29tQ5G9Q7n9no0clYSVJ9+BYIklS4vhR9RJwXEfdExN6IWDPF/N+OiLsi4nB1qWbzvI9GxK6I2BMRn4yImONs74+I3RGxIyI2RcQLm+atiIh7q9uKbubqJFtEnBUR36q+bzsi4q11ydY0/zkRsT8irq9Ttoh4QUR8rfp52x0RQzXK1u/nwh9FxM6I2B4Rdza/+j0irqzWuycizu1mrk6yRcQbImJbNW9bRLy2Ltma5r8gIiYi4gNdC5WZc3qjcXL2PuBXgBOA/wCWTFpmCPgN4LPAW5rGfwv492ob84BvASNznG0U+OVq+o+BL1bTpwL3V/8uqKYX1CTbi4HF1fTzgYPA/Dpka5r/CeDzwPV9+Hk7ZjZgHHhDNT1wZLl+Z6vJc+E5TdNvAr5aTS+plj8ReFG1nXk1yfYy4PnV9EuBA334eZsyW9PYl4B/Bj7QrVz92KN/8u0RMvN/gCNvj/CkzNyXmTuAX0xaN4FfovENPBE4Hjg0x9k2Z+bPqrtbaLxGAOBcYGNm/jgzHwE2AufVIVtmfj8z762m/xN4CGj5Iou5yAYQEcuAQeBrXczUcbZqT+u4zNxYLTfRtFxfs1GP58J/Nd09ucpEtdxYZj6RmQ8Ae6vt9T1bZn6veg4A7AJOiogT65ANICIuAh6osnVNP4q+7bdHyMxvAZtp7JEeBO7IzD19zHYZcHub685ltidFxNk0yuG+OmSLiGcB1wLd+zO1S9lo/CX0k4i4JSK+FxEfi8Yb9vU9W12eCxFxeUTcB3wU+NPZrNunbM1+H7grM5+oQ7aIGAA+CPxFF/MAT7OTsRHxa8Cv09irWQS8NiJe06csbweGgY/14/Gnc6xsEbEQ+EfgXZk5+a+lfmV7L7AhM/f3I0+zKbIdB7yGxi+hV9D4c3xlHbLV5bmQmZ/KzF+lUVB/PtePP53pskXEmcBfAe+pUbargY9n5kS3H69n19FPo+XbI0zjzcCWI9+IiLgdeBXwb3OZLSJeD1wF/E7T3sABYGTSuuNdytVpNiLiOcBtwFWZuaWLuTrN9irgNRHxXhrHwE+IiInMfMpJrD5k2w9sz/9/F9Z/Bc4BbqhBtlo8F5qMAZ9uc925zEZEnA58GXhnZnbzL9tOs70SeEtEfBSYD/wiIv47Mzu/QKGbJyJmcqPxy+V+GidpjpysOPMYy36Go0/GvhX4erWN44FNwBvnMhuNkzn3UZ3cbBo/lcaxtQXV7QHg1JpkO6H6Xv1Zv/5Pj5Vt0jIr6f7J2E6+b/Oq5Z9b3f8H4PKaZKvDc2Fx0/Qbga3V9JkcfTL2frp7MraTbPOr5X+vj8+FKbNNWuZqungytutf6Ay/GRcA369+gK+qxv4SeFM1/Qoae1OPAT8CdlXj84C/BfbQeG/76/qQ7es0Tnptr27rm9Z9N40TT3tpHB6pRTbg7cD/No1vB86qQ7ZJ21hJl4u+C/+nbwB2ADtp7HicUIdsNXkufILGScPtNM4XnNm07lXVevcA59clG43DJI9Nei48rw7ZJm3jarpY9L4yVpIK97Q6GStJmj2LXpIKZ9FLUuEsekkqnEUvSYWz6CWpcBa9JBXOopekwv0fkg6dh/BNg7kAAAAASUVORK5CYII=\n", "text/plain": [ "
" ] }, "metadata": {}, "output_type": "display_data" } ], "source": [ "pd.Series(tvds).hist()" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "Finally, compare the TVD between the 10468 sample and all NYC complaints with the histogram, and decide whether to reject the null hypothesis or not." ] } ], "metadata": { "kernelspec": { "display_name": "Python 3", "language": "python", "name": "python3" }, "language_info": { "codemirror_mode": { "name": "ipython", "version": 3 }, "file_extension": ".py", "mimetype": "text/x-python", "name": "python", "nbconvert_exporter": "python", "pygments_lexer": "ipython3", "version": "3.4.8" } }, "nbformat": 4, "nbformat_minor": 2 }